?
Solved

Convert SSIS Package into VBA

Posted on 2007-04-05
4
Medium Priority
?
766 Views
Last Modified: 2013-12-25
I would like to use vba to upload flat files into a SQL Server 2005 database.  SQL Server 2000 allowed you to record a DTS upload package in VBA but SQL Server 2005 does not offer this option.  Instead it allows you to record a SSIS upload package.  

Is there any way to create the vba code for uploading into SQL Server 2005 or convert the recorded SSIS package into VBA?

Thanks
0
Comment
Question by:Linda_Zhang
2 Comments
 
LVL 29

Expert Comment

by:leonstryker
ID: 18863863
I have never seen a SSIS package, but coding VBA to upload a file to SQL Server is fairly straight forward, and depends on the structure of the file.   How does the file look and how does the table look?
0
 
LVL 15

Accepted Solution

by:
CSLARSEN earned 2000 total points
ID: 19282620
A colleague of mine made this work:
Use a command shell to run the SSIS package
Enter "dtexecui.exe" in start->Run

cheers
cslarsen
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question