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 |
|
Rajeev_calling
Starting Member
10 Posts |
 Posted - 2009-09-22 : 07:14:04
|
| One of my task is to create a SSIS package(i have little idea about DTS pacakge in sql server 2000). My task is to read a flat file and then to call stored procedure based on that.I am new to SQL server database , not having much idea how can i create a package or from where to start. Database at present is fully functional i.e it has tables,procedures...Any help would be appreciated. Thanks! |
|
|
ozsql
Starting Member
14 Posts |
Posted - 2009-09-22 : 09:05:45
|
| You need to create view first joining multiple tables as per the requirements and then create package. Note: you need to select query pointing to source in connection manager so you can run query based, the one you created in view. They are lot'z of other ways to create packages it all depends on your requirement.If you are new to SSIS need to download video based tutorials available from AppDev, watch those videos and create packages. You can download it from rapidshare you need to download all the 13 parts : http://filespump.com/download_file.php?file=12238676&desc=appdev+c+sharp+8cds+coursebook+completed.part01.rarAll the best |
 |
|
|
|
|
|
SSIS package - Need urgent help