Execute SQL Task ?????
Hi, How to use Execute SOL Task. Along with Data Flow Task etc.. Can anyone help me out with creating a package (importing n exporting data ) using a Execute SQL Task. I need to upload data from excel file and send to DB. But if the data already exists in the table , the TRUNCATE using Execute SQL Task. Please Help. Thanks & Regards, BhavikaThanks & Regards, Bhavika
March 28th, 2011 10:08am

Use execute sql task to truncate the table using truncate command. After that use a data flow task with an excel source to pull data from excel file. Connect execute sql task to data flow task using the green connector (precedence constraint) from execute sql task.Nitesh Rai- Please mark the post as answered if it answers your question
Free Windows Admin Tool Kit Click here and download it now
March 28th, 2011 10:24am

Hey Thanks a lot it is done. Can you please help me with logging the errors i am unable to do that ??Thanks & Regards, Bhavika
March 28th, 2011 10:31am

What kind of error logging you want to do? There is a logging feature available in SSIS which can be enabled and configured by going to SSIS manu and clicking on Logging option.Nitesh Rai- Please mark the post as answered if it answers your question
Free Windows Admin Tool Kit Click here and download it now
March 28th, 2011 11:21am

1 ) When i am exporting my Data from Excel to a Database Table. , If any errors comes. I need to log them in a error table .Thanks & Regards, Bhavika
March 28th, 2011 11:42am

You can use event handlers in SSIS. For handling errors inside data flow task you can configure the error output of the various components and redirect them to an error table.Nitesh Rai- Please mark the post as answered if it answers your question
Free Windows Admin Tool Kit Click here and download it now
March 28th, 2011 11:55am

I will explain the scenario . I have a template (Excel or CSV FILE) that i need to import into database(all data to Staging DB ). Where two tables are required. 1) DataTable(Example1) : Which will contain all imported data from excel .(Achieved) 2) Error table : which will contain any error that have occured while importing from Excel to DB(not achieved) After this , I need to send the data from table(Example1) to actaul table say (ActualTable). Here, when i am sending data from Example1 ----> ActualTable (using SP's) , i want that i should add some custom column in Example1 which will tell me that when i send data to ActualTable , how many columns have been affected (say : Success ). While Transfer i even want a 2nd ErrorTable where i would like to log some custom errors, depending on the Business validations of my project. Thanks & Regards, Bhavika
March 28th, 2011 1:06pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics