July 30, 2013 at 11:47 pm
Please note that Script Tasks and Script Components are different things. Using the terms interchangeably will confuse people who know the difference.
Script Tasks are used in the Control Flow (and are probably what is needed here).
Script Components are used only in data flows.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
July 31, 2013 at 12:36 am
Here is an alternative article you can follow if you would like a different way of doing it with SSIS
http://qa.sqlservercentral.com/articles/Integration+Services+(SSIS)/87652/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 31, 2013 at 7:38 am
Phil Parkin (7/30/2013)
Please note that Script Tasks and Script Components are different things. Using the terms interchangeably will confuse people who know the difference.Script Tasks are used in the Control Flow (and are probably what is needed here).
Script Components are used only in data flows.
Phil, thanks for reminding me how long I've been away from SSIS. :crying:
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 1, 2013 at 9:47 am
I ended up using Alvin's recommendation and write c# code in the script task.
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply