March 7, 2008 at 5:51 am
I've been doing SQL Server for about 6 weeks, teaching myself from sites like this, while waiting for my course to come up.
I've been posting on the SSIS thread, trying to find out how to connect a remote drive at run time.
The code to do it already exists in the access database we are replacing.
It seems that VBScripts are the thing. I've found loads of examples of VBScripts but nowhere does it say where they would be built.
I've been building packages in BIDS SSIS and stored procedures in SQL Server Management studio. Neither of these places seem appropriate. Also, I've got 5 books covering various aspects of SQL Server 2005 and none of the indexes mention VB Script.
Am I missing some kind of editor? Sorry if this is too basic. :unsure:
March 12, 2008 at 12:48 pm
You apologize for the question being basic I hope you don't mind the answer basic as well!
Open SSIS, on the control flow select the Control Flow item 'Script Task'. Drag to the Control Flow desktop.
Highlight/edit here you will see the properties, in the lower left hand corner select 'Design Script'
This will bring up Visual Basic app. You can start VB Scripting here.
March 13, 2008 at 8:09 am
VB Script has been included in SSIS 2005 only for backwards compatability. It has been deprecated and accorading to MS will be removed from the next version. According to them, it shouldn't be used for any new development.
You should use VB.NET in the script task instead.
I have lots of VB Script from SQL 2000 DTS, so I feel your pain on this on.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply