Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ravi0435
Starting Member
47 Posts |
 Posted - 2007-05-17 : 10:14:28
|
| Hi all, I am new to SSIS...and wanted to know where can i get a lot of info on how to deal with ActiveX Scripttasks & Script tasks in SSIS...the place i am working has a lot of VB Scripting done in DTS Packages...having a hard time in understanding the Scripts, as i am more like back-end guy and wanted to learn a lot in SSIS, once i understand the scripts it will help me a great deal as to how to approach the tasks...Is there any website which teaches how to avoid Scripting in SSIS as i read somewhere that Scripting should be avoided as much as possible by making using of so many tasks in the SSIS tool.I will look forward for someone to help me out and show me a way.thanksraviNothing much that i can do..!! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-05-17 : 10:44:31
|
| There's no where near as much scripting needed in ssis as there was in dts. I think the only time I have used it (as a necessity) is for FTP.Have a look www.sqlis.comThe FTP thing I did is herehttp://www.simple-talk.com/sql/sql-server-2005/quick-tip-performing-an-ftp-rename-in-a-ssis-script-task/There's other ssis stuff on that site too.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
About Scripting in SSIS.