| Author |
Topic |
|
Rupa
Posting Yak Master
123 Posts |
 Posted - 2007-06-07 : 05:05:11
|
| Hey allI tried to use the SQL Server 2005 setup file to try and locate the Integrated Services but it's not on there. Where else can I find SSIS?? Help!!!Many thanks,Rupa |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-06-07 : 05:09:55
|
| SSIS does not come as a separate start-menu item. You can work on SSIS by creating SSIS project from Visual Studio IDE.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
Rupa
Posting Yak Master
123 Posts |
Posted - 2007-06-07 : 05:26:38
|
| Thanx Harsh..All I want to do is import data into a table (on SQL Server 2005) and it gives me an error message. Having read the forums, I understand that I need SSIS....How wld I go abt this? Many, many thanksRupa |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-06-07 : 05:32:19
|
| You can use Import and Export wizard in SQL 2005, if you want to do something as simple as that.In the Business Intelligence studio, click SSIS Import and Export Wizard in the Project menu. Then following wizard steps should be pretty simple.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
Rupa
Posting Yak Master
123 Posts |
Posted - 2007-06-07 : 05:49:36
|
| Thank you soo much Harsh..I tried that while I was waiting for a reply and it said 'Successful' but when I opened the table...the data from the .csv file wasn't there?? Any ideas??I really appreciate your help...many, many thanksRupa |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-06-07 : 06:03:03
|
| Are you importing data in an existing table or you are creating new table from package itself?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
Rupa
Posting Yak Master
123 Posts |
Posted - 2007-06-07 : 06:22:39
|
| Existing..and I refreshed the database as well but still no sign of data...renamed the columns to match the columns in existing table...still no luck..Any ideas?Many thanksRupa |
|
|
|
Rupa
Posting Yak Master
123 Posts |
Posted - 2007-06-07 : 11:16:10
|
| It's done it...thank you anyway Harsh.Rupa |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-06-07 : 11:17:35
|
| You can share the solution so that others can benefit, if they face similar problem.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
Rupa
Posting Yak Master
123 Posts |
Posted - 2007-06-11 : 04:26:59
|
| It was really simple really. I'm not use to SQL server 2005 where u have to execute the procedure first and then execute it again. Similarly, in the Business Intelligence Studio, I had to execute it first so it saves it and then had to execute it again to run it. So when it first said 'Successful', it just meant that it's saved it without errors. But it didn't actually execute it. Hope this makes sense.Rupa |
|
|
|
|
Where can I find SSIS