Hi, All
Since I install SQL 7 SP3 twice, in EM/DTS/local packages, open any pacakage, right click one of the step, one of the drop down item 'execute step' was missing. Does anyone know how to bring it back?
Thank you in advance!
Theresa
I have a package that has multiple data flow tasks. At the end of a task, key data is written into a raw file (file name stored in a variable) that is used as a data source for the next task. Each task requires a success from the preceding task.
Here's the rub:
If I execute the entire package, the results of the package (number of records of certain tasks) differs significantly from when I execute each step in the package in turn (many more records e.g. 5 vs 350).
I get the feeling that the Raw file is read into memory before it is flushed by the previous task, or that the next task begins preparation tasks too early.
Any help is greatly appreciated.
I am running on Server 2003 64 (although the same thing happens when deployed on a Server 2003 32 machine)
Thanks
B.
Have 10 pkgs in an SSIS solution. All share a common data source but none of the pkgs call each other. I store everything on the hard drive. I build the solution and it builds all the 10 pkgs and places the 10 pkgs in the bin folder.
When I call a pkg from a job step, do I just want to point to the pkg in the bin folder. It works either way, calling the pkg in the bin and non-bin folder. Im thinking I should call the one in the bin folder. Or should I be calling the pkg somehow with the syntax - MySSISsolution.Pkg3?
I have a DTS package that I want to execute from within a sql 7.0 scheduled task step. I tried the following and got the following error on the DTS step:
Operating System Task:
dtsrun /S 'Server1' /E /N'REFRESH'
Error Thrown:
DTSRun: Loading... Error: -2147008507 (80074005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 713 Error: -2147467259 (80004005); Provider Error: 11 (B) Error string: [DBMSSOCN]General network error.
Can someone help me with the syntax? Suggestions?
Dear all hi,
I would like to create a job in my database to be occurring once a day. This job runs a dts package for transfer data in some tables that we have in other kind of database(Access). The Dts package first delete the rows and then insert the new rows.
I have defined the relationships in my database. I want the job to be
Step 1: run the d:sqlscriptsDrop_relation.sql
Step 2:execute dts package
Step 1: run the d:sqlscriptscreate_relation_w_2006.sql
I couldnt find a command like sp_execute d:sqlscriptsDrop_relation.sql a command that i can run an in query analyzer. Has anyone any suggestions?
Best Regards,
Hellen
This is a bug that I submitted to Microsoft. I wanted to see if anyone could assist me with a work-around.
1. Create a new DTS Package
2. Add an ActiveX Task and change 'Main = DTSTaskExecResult_Success' to 'Main = DTSTaskExecResult_Failure'.
3. Running this package will result in a Failed package.
4. Save Package as 'Failure' to local server
5. Create another new DTS Package.
6. Add an 'Execute Package' task, and configure the properties to have it launch the saved 'Failure' child package.
7. Add an ActiveX task and then click ok to close it.
8. Select the Execute Package task (which executes the failure package), hold control and click the ActiveX task. Add an 'On Success' Precendence constraint from the 'Workflow' menu.
9. Now execute the package. Notice that the ActiveX task will execute even though the Execute Package task FAILED.
10. If you change the Precendence constraint from 'On Success' to 'On Failure' the ActiveX task will not run, because the package thinks that the Execute Package task completed with success.
In summary... if a child package, executed by an Execute Package task fails, the Execute Package Task ALWAYS "reports" success to the following precedence constraint and the package continues to run. Even if 'Fail Package on first error' is enabled. Although you will see that the task actually failed while watching the status of the package execution.
I am currently trying to write vbscript in an ActiveX task that will follow an Execute Package Task. I am trying to make the vbscript check and see if the previous task really did succeed or fail, and then make the ActiveX task succeed or fail as required to make the precedence constraints work properly.
I have replicated this problem on many different machines.
---------------------------------------------------------------------------
Any ideas for my ActiveX task? I am trying to access the StepExecutionResult from the Execute Package task, and I have been unable to. If I can get the Step Execution reult, then I can in turn cause the ActiveX task to suceed or fail, based on the execution result of the Execute Package task.
Thank you for your time,
David Zebrowitz
dzebrowitz@apartners.com
I have this SSIS package which just doesn't seem to run when executing as a sql job and I keep getting this error:
"The command line parameters are invalid. The step failed."
I read some of the comments in forums and they were suggesting to verify the command line for the sql job since there is known bug in the command line for sql job.
But that didn't seem to resolve it and the reason could be one of the variable values that I am trying to set.
In this package one of the variables that I am trying to set is the connection string and my command line looks like this
dtexec /SQL "TestPkg" /SERVER [SVRNAME] /MAXCONCURRENT "-1" /CHECKPOINTING OFF
/SET " package.variables[User::MetaDataConnectionString].Value";"Data Source=[SVRNAME];Initial Catalog=[DBNAME];Integrated Security=True;"
When I try to run this from the command line I get the error as:
Argument " package.variables[User::MetaDataConnectionString].Value;Data Source=[SVRNAME];Initial Catalog=[DBNAME];Integrated Security=True;""
for option "set" is not valid.
I think the issue is in the set parameter where it seems to be intepreting the ;'s in the connection string as part of its command (which I seem to be escaping by putting them in quotes but it seems to be stripping them off)
Has anyone else encountered this issue? Is there any other escape character that I should be using?
Any help will be greatly appreciated.
Hi all,
I am new to SQL Server 2005 (but many years in SQL Server and .NET), and I am sort of having everything figured out for my company. However, one thing that still bothering me is that:
In the old Server 2000, you can execute a single step in a DTS package by right click the step and then click execute step.
In the new server 2005, I can only execute the whole package from the Management Tool and Edit the pack from VS 2005. Is there also a way for me to execute a single step in a SSIS package?
This is important for us, many thanks!
I have a package that used to work fine, but after I imported it into a different existing solution and tried to run it, it always stalls during the data flow task at the very end.
It will run through and process all the rows and insert them into the destination except for the last chunk. The task blocks eventually all turn green as well, but then it never proceeds to the next task after the data flow. Looking at the Progress tab for the data flow task, I get the following:
Progress: Pre-Execute - 100 percent complete
[DTS.Pipeline] Information: Execute phase is beginning.
[DTS.Pipeline] Information: Post Execute phase is beginning.
Progress: Post Execute - 0 percent complete
Then it just stays at 0 percent for Post Execute. The program doesn't hang or anything, it just doesn't progress at all. I also just checked and I run the package from its original solution and it is now exhibiting the same behavior as well.
Any ideas what might be causing this or something to do to try and figure it out or at least get more information about what might be causing it?
Thanks.
Hi All,
Please let me know where can i find the sample files and rs2005sbsDW database in msdn library as i dont have CD provided along with the book.
Please give me the link of the sample files so that i can download it for testing the sample application.
Regards,
Prabhanjana
is there such a paper? if so, can you pls point me to it? thx in advance
View 4 Replies View Relatedhye everyone,
after finished do the report and deploy at IIS/report manager in local pc..
i want to know , what is the step /how to deploy the report project at the user's pc/ client pc /other server..
thanks in advance
thank you very much
I want to convert .rdlΒ to .rdc need full steps.Actually i created .rdl report using sp sucessfully.Now i want to convert it to rdlc while doing it iam getting some authentication error and some thing else.I created rdl in 2008 and i want to change it to rdlc 2010.
View 5 Replies View RelatedHi!
I hope the answer is as simple as the question -- but after reading all the documentation I could find (understand?) and a lot of posts here, I'm no closer to achieving the goal.
I have a Visual C# app, DAYTRACKER, developed in VS2005. It uses a database with several tables constructed using SQL Server 2005 Developer Edition.
I want to deploy the app plus the database plus SQL Express to another machine, to be used by a single user (the administrator) with no need for network connectivity of any kind.
What I have so far is:
1. The application is successfully deployed from a CD-ROM, having used the Publish process within VS2005, and opens on the new machine -- without database connectivity, however.
2. SQL Express is successfully deployed (it deployed as a 'prerequisite' when I went through the Publish process in VS2005)
3. I manually copied the database's .mdf and .mdl files, using SQL Server Managers 'Copy Database' function, then transferred the copies to the new machine into the ..MSSQL.1MSSQLdata folder (where they appear along with the master.mdg, mastlog.ldf etc files)
Now, the DAYTRACKER application's DAYTRACKERConnectionString under 'Settings' in the VS2005 studio reads 'Data Source=DELL3;Initial Catalog=DayTracker;Integrated Security=True' (which are the appropriate parameters for the machine, DELL3, on which I wrote the program.)
The problem, of course, is that SQL Express on the new machine doesn't connect the application to the database. When I go to the 'SQL Server Configuration Manager' and go to the 'SQL Server 2005 Services' and double-click on the 'SQL Server (SQLEXPRESS)' icon (the service is running) and the user is logged on using 'Local System Account'. Under the 'Service' tab the Host Name is 'MUSIC' (which is the name of the new machine I've installed the app onto -- which of course is not the name - DELL3 - that the app's connection string is expecting). Under the 'Advanced' tab, I've tried correcting the name of the Startup Parameters default .mdf and .mdl entries to ..DayTracker.mdf and ..DayTracker_log.mdl, but the server won't start up after I make the changes.
What I'm hoping for: a step-by-step way of doing this type of deployment, preferable getting it all onto one CD-ROM, and installing it on the new machine so that it all works seamlessly from the start, not requiring any 'tweaking' of the SQLServer Express settings by the end-user.
But I'll take pretty much anything that fixes the specific db connectivity problem I've described.
Thank you very much.
John F.
I'm having a hard time to getting back an xml data back from a stored procedure executed by an Execute SQL task.
I'm passing in an XML data as a parameter and getting back resulting XML data as a parameter. The Execute SQL task is using ADO connection to do this job. The two parameters(in/out) are type of "string" and mapped as string.
When I execute the task, I get the following error message.
[Execute SQL Task] Error: Executing the query "dbo.PromissorPLEDataUpload" failed with the following error: "The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 2 ("@LogXML"): Data type 0xE7 has an invalid data length or metadata length.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
I also tried mapping the parameter as XML type, but that didn't work either.
If anyone knows what's going on or how to fix this problem please let me know. All I want to do is save returning XML data in the parameter to a local package variable.
Thanks
Hi,
I have to transport a big database table and can't read it at once with "select * from table" because the table is bigger than my system memory.
Is there a way to read the table step by step? I thought it was possible with ADO and his serverside cursors but I don't now how. I need an "universal" solution that works on SQL Server 2000/2005, MySQL and Oracle.
Regards,
harry
Connecting to a networked SQL Server Box from my local machine
Open Query Analyzer from Start menu, logging in using sa account.
from the object browser i select my stored procedure (WEA_InsertClaim) - right click and select Debug.
i am prompted to enter the parameter values, which i do, auto rollback checkbox is checked - click Execute.
T-SQL Debugger opens and runs through the stored procedure.
but only buttons enabled are the "Go", "Toggle Breakpoint", "Clear All Breakpoints"
so i can set breakpoints etc. but when i select Go it will not stop at the breakpoints it just runs through the stored procedure from start to finish. giving the correct return code as its output
is there something i need to enable in order to make it stop at breakpoints??
Cheers,
Craig
Is there a good step by step guide to setting up an indirect configuration? I've followed the steps in Kirk Haselden's 'Keep your packages in the dark' article 3 or 4 times this afternoon and nothing seems to work. I cannot even get the XML configuration file to work by accessing it directly. I'm using the wizard to create the file.
Just wondering if there was something else out there....
Thanks in advance for any help.
MarkA
Hi
I posted this on the sql server security forums too. Here is the error that i get when i change the type of the step to ssis
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
Additional information:
An exception occured while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.(Microsoft SQL Server, Error: 3930)
This error pops up right after i change the type of the step to "SQL Server Intergration Services Package"
I have made the following configurations:
The user group (windows group) that the user belongs has the following roles in msdb :
db_dtsadmin
db_dtsltuser
db_dtsoperator
SQLAgentOperatorRole
SQLAgentReaderRole
SQLAgentUserRole
i have made a proxy to sql server agent which has the following subsystems :
"SQL Server Integration Services Provider" the proxy is tied to the same login which has those SQLagent and dts roles in msdb database.
Im using windows authentication and the user that logs into the sql server is in the same group that i have set all of the rights.
Ps. Clearly im missing some role or right somewhere because as soon as i give the group sysadmin role then all the users in that group can create SSIS steps in the agent.
Ps. Ps. I have been living under the impression that i dont have to give sysadmin rights to people that create ssis packages and schedule then with the agent.
I am trying to learn Reporting Services using the title "MS SQL Server 2005 Reporting Services Step by Step" by Stacia Misner and Hitachi Consulting, published in 2006. I am experiencing problems with some of the exercises. I got as far as Chapter 4 when I followed directions to create a SQL statement to define a query string for a dataset. Pg 80:
select * from vProductProfitability
where year = 2003 and
MonthNumberOfYear = 1
The view vProductProfitability does not exist in the tutorial database that came with the book, rs2005sbsDW. The result of this query is the basis for the entire chapter on developing basic reports and I'm being denied a learning opportunity because the view does not exist. In short, I'm stuck.
I have tried to find somewhere at Microsoft to place this question and get some answers so I can continue thru the tutorial. To no avail. Does anyone have any suggestions?
BTW, the solution that came in the CD is also wrong because the query noted above is also in the solution.
This humble grasshopper seeks wisdom.
Respectfully Submitted,
Dave Matthews
Atlanta, GA
aka FlooseMan Dave
Hello,I'm trying to create a simple back up in the SQL Maintenance Plan that willmake a single back up copy of all database every night at 10 pm. I'd likethe previous nights file to be overwritten, so there will be only a singleback up file for each database (tape back up runs every night, so each daysback up will be saved on tape).Every night the maintenance plan makes a back up of all the databases to anew file with a datetime stamp, meaning the previous nights file stillexists. Even when I check "Remove files older than 22 hours" the previousnights file still exists. Is there any way to create a back up file withoutthe date time stamp so it overwrites the previous nights file?Thanks!Rick
View 5 Replies View RelatedNew to Database Mirroring and I have a question about the Principal database server. I have a Database Mirroring setup configured for High-safety with automatic fail over mode using a witness.
When a fail over occurs because of a lost of communication between the principal and mirror, the mirror server takes on theΒ roll of Principal. When communication is returned to the Principal server, at some point does the database that was the previous Principal database automatically go back to being the Principal server?
I need to run two reports each of A5 Size to run back to page and print on single A4 paper means in 1st half Sale bill will be printed and in second half Gate Pass Will Be Printed both report will be on same page and size and shape should be maintained. How to do it.
View 4 Replies View RelatedDear Experts,
please guide me for replcation.....
i'm using sql server 2005 server tools developer edition. my OS is professional 2000.
and i've sqlserver 2000 client tools also
i've two databases in my machine. publisher is in different instance, and the transactions might be maximum 50 per day. my aim is when ever developer enters the data into the main database, automatically it should be updated on the my two databases also.
i mean the server is sysA and the database is srtp.
my machine is sys20 and the databases are srtp1, srtp2.
how should i make sysA as publisher?
i've right click on the server databases, but it is showing newsubscriptions option only.
Vinod
Even you learn 1%, Learn it with 100% confidence.
Visual C# 2005 Step by Step John Sharp
Intel D975XBX 930 2GB ram HD 300GB - MatroxVD
Windows XP Sp2 + updates
Visual Studio 2005 Professional edition
SQL Sever 2005 Standard Edition
20070203
Install Practice Files at D:Program FilesMicrosoft PressVisual C Sharp Step by Step.
Configuring SQL Sever Express Edition
Hostname - xxxxxxxxx..
At sqlcmd s xxxxx...SQLExpress E got - Pipes error.
Open Microsoft SQL Sever 2005 - Configuration Tools SQL Configuration Manager select Protcols for SQLEXPRESS select Named Pipes enable close.
At sqlcmd s xxxxx..SQLExpress E get Sqlcmd: : Unknown Option. Enter -? for help.
Chdir C:Documents and SettingsAll UsersStart MenuProgramsMicrosoft Server 2005
Sqlcmd s xxxxxx..SqlExpress E
Hresult 0x2, Lvel 16, State 1
Named Pipes Provider: Couldnot open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
How do I fix this?
Need to be able to to use the Northwind Traders data base
Thanks
Hello,I am hoping you can help me with the following problem; I need to process the following steps every couple of hours in order to keep our Sql 2000 database a small as possible (the transaction log is 5x bigger than the db).1.back-up the entire database2.truncate the log3.shrink the log4.back-up once again.As you may have determined, I am relatively new to managing a sql server database and while I have found multiple articles online about the topics I need to accomplish, I cannot find any actual examples that explain where I input the coded used to accomplish the above-mentioned steps. I do understand the theory behind the steps I just do not know how to accomplish them!If you know of a well-documented tutorial, please point me in the right direction.Regards.
View 2 Replies View Related
Friends -
Could any one of you provide steps for upgrading SQL Server 2000 cluster to SQL server 2005 cluster.
My environment is Windows 2003 server.
Appreciate your support.
Cheers
VSH
Does anybody know of a way to rollback SQL Server 2005
databases back to SQL Server 2000? Is there a way of doing it without
resorting to Copy Database Wizard? I love to find a way of attaching a SS 2005 database
to a SS 2000 instance without any issues.
I recently upgraded to SS 2005 and I am very unhappy with the SS 2005 and I
want to rollback to SS 2000, which was a lot more stable. I am having
several major issues that are affecting my whole company's day-to-day
operations and the managers are not happy. Some of the issues include
night time batch running very sluggish for no apparent reason. This is a
biggest problem because it only occurs once or so a week and causes a disturbance
with the daily activities when the night time processing isnt completed on
time. The rest of the time, the batch processing runs great, even a little better then on SS 2000. I
don't believe it is a matter of my application needing to be retuned because if
that was the case, then why isn't it running sluggish every night? Also,
it's never the same day that the sluggish behavior occurs. If it was occurring
on the same night, then I would have something to investigate within our
application, but it doesn't. Another issue that I am having involves a
night time job that restores a copy of the production database to the Data
Warehouse server to be used for updating the data warehouse. Again, most
of the time it runs great (~2 1/2 hours), but once or twice a week, it goes
stupid and takes 6 1/2 hours for no apparent reason. Again, it is not happening
the same day either, which could give me something to invesigate. On SS 2000, this same job ran flawlessly. Never I did I run into situation that the
database restoration took that long to run. Even another issue involves a SQL Server Agent Job that was put into suspended
state. What's a suspended state and how can I get it out of suspended
state? I can find no information about suspended state in BOL. I
did a Google and nothing came up. If this suspended state was put
in for security reasons, great, but then tell me how I can remove the suspended
state. I am also not happy with the
fact that I can't get accurate information about the queries that are actively
running at that particular moment. In SS 2000, when I noticed high CPU
usage on the server, I would run the sp_who2 active stored proc and it would
show me all the active thread and how much CPU it was consuming. I would
then find the running threads with the highest CPU numbers and investigate the
query and see if we could improve it. Now in SS 2005, I get in the same
situation and run the sp_who2 stored proc, and there is no smoking gun.
All of the active threads are showing very little CPU usage, which I am very
suspect of. What the heck happen to sp_who2? I looked at some of
the other ways of looking at running processes (i.e... sys.sysprocesses) and
they don't appear to be giving the information that I need.
I am very unhappy and I just want to roll back to SS 2000 and wait a couple of
years before I upgrade to SS 2005.
Dave Brown
Dear all:
I had got the below error when I execute a DELETE SQL query in SSIS Execute SQL Task :
Error: 0xC002F210 at DelAFKO, Execute SQL Task: Executing the query "DELETE FROM [CQMS_SAP].[dbo].[AFKO]" failed with the following error: "The transaction log for database 'CQMS_SAP' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
But my disk has large as more than 6 GB space, and I query the log_reuse_wait_desc column in sys.databases which return value as "NOTHING".
So this confused me, any one has any experience on this?
Many thanks,
Tomorrow
I'm looking for a way to refer to a package variable within any
Transact-SQL code included in either an Execute SQL or Execute T-SQL
task. If this can be done, I need to know the technique to use -
whether it's something similar to a parameter placeholder question
mark or something else.
FYI - I've been able to successfully execute Transact-SQL statements
within the Execute SQL task, so I don't think the Execute T-SQL task
is even necessary for this purpose.
Hi.
I have a master package, which executes child packages that are located on a SQL Server. The Child packages execute other child packages which are also located on the SQL server.
Everything works fine when I execute in process. But when I set the parameter in the mater package ExecutePackageTask to ExecuteOutOfProcess = True, I get the following error
Error: 0xC00470FE at DFT Load Data, DTS.Pipeline: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "Row Count" (5349).
Error: 0xC00470FE at DFT Load Data, DTS.Pipeline: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "SCR Custom Split" (6399).
Error: 0xC00470FE at DFT Load Data, DTS.Pipeline: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "SCR Data Source" (5100).
Error: 0xC00470FE at DFT Load Data, DTS.Pipeline: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "DST_SCR Load Data" (6149).
The child packages all run fine when executed directly, and the master package runs fine if Execute Out of Process is False.
Any help would be greatly appreciated.
Thanks
Geoff.
I have a SSIS package contains an "Execute SQL Task". The SQL will raise error or succeed. However, it sounds the package won't pick up the raised error?
Or is it possible to conditional run other control flow items according the the status of SQL task execution?
I am trying to run the code below as a step in a job, but I cannot get this much code in the step. Is there another way of running this code? I tried putting the code inside of an SP, but I got errors there too.
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
COMMIT
BEGIN TRANSACTION
CREATE TABLE dbo.Tmp_importthis
(
Confirmation varchar(50) NULL,
StartDate datetime NULL,
C1_1 char(3) NULL,
C1_2 char(6) NULL,
C1_3 datetime NULL,
C1_4 datetime NULL,
C1_5 varchar(55) NULL,
C1_6 money NULL,
C1_7 int NULL,
C1_8 char(9) NULL,
C1_9 varchar(5) NULL,
PRDept char(2) NULL,
TypeVisit int NULL,
C2_1 int NULL,
C2_2 int NULL,
C2_3 bit NULL,
C2_4 int NULL,
C2_5 bit NULL,
C2_6 varchar(50) NULL,
C2_7 char(1) NULL,
C2_8 char(1) NULL,
C2_9 char(1) NULL,
C2_10 char(1) NULL,
C2_11 char(1) NULL,
C2_12 char(1) NULL,
C2_13 char(1) NULL,
C2_14 int NULL,
C2_15 bit NULL,
C2_16 bit NULL,
C2_17 bit NULL,
C2_18 bit NULL,
C3_1 int NULL,
C3_2 int NULL,
C3_3 bit NULL,
C3_4 bit NULL,
C3_5 bit NULL,
C3_6 bit NULL,
C3_7 bit NULL,
C3_8 bit NULL,
C3_9 bit NULL,
C5_1 bit NULL,
C5_2 bit NULL,
C5_3 bit NULL,
C5_4 bit NULL,
C5_5 bit NULL,
C6_1 bit NULL,
C6_2 text NULL,
C6_3 bit NULL,
C6_4 text NULL,
C6_5 bit NULL,
C6_6 text NULL,
C6_7 bit NULL,
C6_8 bit NULL,
C6_9 bit NULL,
C6_10 text NULL,
C7_1 bit NULL,
C7_2 bit NULL,
C7_3 bit NULL,
C7_4 bit NULL,
C8_1 int NULL,
C8_2 int NULL,
C8_3 bit NULL,
C8_4 bit NULL,
C8_5 bit NULL,
C9_1 bit NULL,
C9_2 bit NULL,
C10_1 bit NULL,
C11_1 bit NULL,
C13_1 bit NULL,
C13_2 bit NULL,
C13_3 bit NULL,
C13_4 bit NULL,
C13_5 bit NULL,
LODept char(1) NULL,
C15_1 int NULL,
C15_2 int NULL,
C15_3 bit NULL,
C15_4 int NULL,
C15_5 bit NULL,
C15_6 varchar(50) NULL,
C15_7 char(2) NULL,
C15_8 char(2) NULL,
C15_9 char(2) NULL,
C15_10 char(2) NULL,
C15_11 char(2) NULL,
C15_12 char(2) NULL,
C15_13 char(2) NULL,
C15_14 int NULL,
C15_15 bit NULL,
C15_16 bit NULL,
C15_17 bit NULL,
C15_18 bit NULL,
C15_19 varchar(255) NULL,
C16_1 bit NULL,
C16_2 text NULL,
C16_3 bit NULL,
C16_4 text NULL,
C16_5 bit NULL,
C16_6 text NULL,
C16_7 bit NULL,
C16_8 bit NULL,
C16_9 bit NULL,
C16_10 text NULL,
C16_11 bit NULL,
C16_12 char(10) NULL,
C16_13 text NULL,
C16_14 bit NULL,
C16_15 bit NULL,
C16_16 text NULL,
Comments text NULL
) ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
IF EXISTS(SELECT * FROM dbo.importthis)
EXEC('INSERT INTO dbo.Tmp_importthis(Confirmation, StartDate, C1_1, C1_2, C1_3, C1_4, C1_5, C1_6, C1_7, C1_8, C1_9, PRDept, TypeVisit, C2_1, C2_2, C2_3, C2_4, C2_5, C2_6, C2_7, C2_8, C2_9, C2_10, C2_11, C2_12, C2_13, C2_14, C2_15, C2_16, C2_17, C2_18, C3_1, C3_2, C3_3, C3_4, C3_5, C3_6, C3_7, C3_8, C3_9, C5_1, C5_2, C5_3, C5_4, C5_5, C6_1, C6_2, C6_3, C6_4, C6_5, C6_6, C6_7, C6_8, C6_9, C6_10, C7_1, C7_2, C7_3, C7_4, C8_1, C8_2, C8_3, C8_4, C8_5, C9_1, C9_2, C10_1, C11_1, C13_1, C13_2, C13_3, C13_4, C13_5, LODept, C15_1, C15_2, C15_3, C15_4, C15_5, C15_6, C15_7, C15_8, C15_9, C15_10, C15_11, C15_12, C15_13, C15_14, C15_15, C15_16, C15_17, C15_18, C15_19, C16_1, C16_2, C16_3, C16_4, C16_5, C16_6, C16_7, C16_8, C16_9, C16_10, C16_11, C16_12, C16_13, C16_14, C16_15, C16_16, Comments)
SELECT CONVERT(varchar(50), Confirmation), CONVERT(datetime, StartDate), CONVERT(char(3), [1-1]), CONVERT(char(6), [1-2]), CONVERT(datetime, [1-3]), CONVERT(datetime, [1-4]), CONVERT(varchar(55), [1-5]), CONVERT(money, [1-6]), CONVERT(int, [1-7]), CONVERT(char(9), [1-8]), CONVERT(varchar(5), [1-9]), CONVERT(char(2), [Purchase/ReturnDept]), CONVERT(int, TypeVisit), CONVERT(int, [2-1]), CONVERT(int, [2-2]), CONVERT(bit, [2-3]), CONVERT(int, [2-4]), CONVERT(bit, [2-5]), CONVERT(varchar(50), [2-6]), CONVERT(char(1), [2-7]), CONVERT(char(1), [2-8]), CONVERT(char(1), [2-9]), CONVERT(char(1), [2-10]), CONVERT(char(1), [2-11]), CONVERT(char(1), [2-12]), CONVERT(char(1), [2-13]), CONVERT(int, [2-14]), CONVERT(bit, [2-15]), CONVERT(bit, [2-16]), CONVERT(bit, [2-17]), CONVERT(bit, [2-18]), CONVERT(int, [3-1]), CONVERT(int, [3-2]), CONVERT(bit, [3-3]), CONVERT(bit, [3-4]), CONVERT(bit, [3-5]), CONVERT(bit, [3-6]), CONVERT(bit, [3-7]), CONVERT(bit, [3-8]), CONVERT(bit, [3-9]), CONVERT(bit, [5-1]), CONVERT(bit, [5-2]), CONVERT(bit, [5-3]), CONVERT(bit, [5-4]), CONVERT(bit, [5-5]), CONVERT(bit, [6-1]), CONVERT(text, [6-2]), CONVERT(bit, [6-3]), CONVERT(text, [6-4]), CONVERT(bit, [6-5]), CONVERT(text, [6-6]), CONVERT(bit, [6-7]), CONVERT(bit, [6-8]), CONVERT(bit, [6-9]), CONVERT(text, [6-10]), CONVERT(bit, [7-1]), CONVERT(bit, [7-2]), CONVERT(bit, [7-3]), CONVERT(bit, [7-4]), CONVERT(int, [8-1]), CONVERT(int, [8-2]), CONVERT(bit, [8-3]), CONVERT(bit, [8-4]), CONVERT(bit, [8-5]), CONVERT(bit, [9-1]), CONVERT(bit, [9-2]), CONVERT(bit, [10-1]), CONVERT(bit, [11-1]), CONVERT(bit, [13-1]), CONVERT(bit, [13-2]), CONVERT(bit, [13-3]), CONVERT(bit, [13-4]), CONVERT(bit, [13-5]), CONVERT(char(1), LookOnlyDept), CONVERT(int, [15-1]), CONVERT(int, [15-2]), CONVERT(bit, [15-3]), CONVERT(int, [15-4]), CONVERT(bit, [15-5]), CONVERT(varchar(50), [15-6]), CONVERT(char(2), [15-7]), CONVERT(char(2), [15-8]), CONVERT(char(2), [15-9]), CONVERT(char(2), [15-10]), CONVERT(char(2), [15-11]), CONVERT(char(2), [15-12]), CONVERT(char(2), [15-13]), CONVERT(int, [15-14]), CONVERT(bit, [15-15]), CONVERT(bit, [15-16]), CONVERT(bit, [15-17]), CONVERT(bit, [15-18]), [15-19], CONVERT(bit, [16-1]), CONVERT(text, [16-2]), CONVERT(bit, [16-3]), CONVERT(text, [16-4]), CONVERT(bit, [16-5]), CONVERT(text, [16-6]), CONVERT(bit, [16-7]), CONVERT(bit, [16-8]), CONVERT(bit, [16-9]), CONVERT(text, [16-10]), CONVERT(bit, [16-11]), CONVERT(char(10), [16-12]), CONVERT(text, [16-13]), CONVERT(bit, [16-14]), CONVERT(bit, [16-15]), CONVERT(text, [16-16]), CONVERT(text, Comments) FROM dbo.importthis TABLOCKX')
GO
DROP TABLE dbo.importthis
GO
EXECUTE sp_rename 'dbo.Tmp_importthis', 'importthis'
GO
COMMIT