can u use the script components ? it has pre execute and post

idea is get how rows got inserted from source to destination for each data flow task inside the pkg

i am using SQL server 2012 data tool any work round idea to take the current executing task name

if u get same problem call the sp from the sql agent inside the Sp u call the pkg , i...

hi

just check while running with the SQL agent the ID which you use has all permission to do

any idea how to convert this format "Sep 21 2015 12:00:00:000AM"

that ok fine .. thank you

Hi

did the check the collection has required output coulmns with data

if you explain your problem with addtional information it will be helfull

Are you buliding the query , reading the data from flat file ?

i fixed the issue , i have use same varaible name in both parmater and inside the ssis variable that was causing the issue i changed the...

Hi

I fixed the issue . the issue is due to the same variable is used in the project parmeter & variable , i have the changed the...

i am trying with the flat file source , but i want to know how to set or assign the dataset values to the variable...

my columns are dynamic so i bulid the columns dynamic and add the data , is it possible to set the data to the variable...

Enterprise Edition

Just to add my pervious code is working fine with out any error which was developed in VS 2010

I don't...

I am upgrading the code from 3.5 to 4.0 Framework I referenced the SQL 2012 DLL as reference in project when ...