June 11, 2012 at 6:04 am
Hello,
I'm trying to create my first project in BIDS, and there open a package (dtsx file).
For some reason 'Prepare SQL Task' is missing from the diagram in the Control Flow tab.
Does any know from what I have explain what I try to do, how I get 'Prepare SQL tack' to be displayed? Is it possibly a setting in BIDS or anything I've missed in the package?
If there is anything I more I can give to explain what I've done, please let me know.
Thanks in advance,
June 11, 2012 at 6:06 am
There is no "Prepare SQL Task" it is "Execute SQL Task"
June 11, 2012 at 6:13 am
This is strange, and I'm completely confused, as it's mentioned in various tutorials and the book about Integration services I'm trying to learn from.
I'm using 2005 version, I should probably have mentioned that.
Any other ideas?
June 11, 2012 at 6:15 am
which book are you reading from?
June 11, 2012 at 6:20 am
Hands-On Microsoft
SQL Server 2005 Integration Servces - by Ashwani Nanda
June 11, 2012 at 6:28 am
for example
Page 47 - Chapter 2 SQL Server Import and Export Wizard
Point 7 - In the control flow double click the preparation sql task
If you read the rest of the line it details that this opens a Execute SQL Task.
Preparation SQL Task is the name given to a Execute SQL Task.
June 11, 2012 at 6:36 am
Yes.. but the problem is, on my Control Flow diagram, there is only 'Data Flow Task', so I can't double-click on Preparation SQL Task.
So, that's why I'm stuck, I'm trying to figure out why that icon/functionality does't exist for me.
I have done point 4 in page 46, but still it doesn't display.
Thank you so much for helping me out, by they, I really appreciate this!
June 11, 2012 at 6:45 am
I would say you have opened the wrong solution, either the solutions do not match the book, or someone has modified the solutions.
Do you have the book CD and reading the solutions from the CD?
June 11, 2012 at 6:56 am
I don't have the book CD, and I created the solution myself, using the exercise on p22.
I also created the package myself, if that is to any help.
I've tried it all twice (different names, both the package and the solution) to see if there was anything in the instructions that I had missed the first time, but the same issue appeared even the 2nd time.
June 11, 2012 at 7:01 am
skimming over the book, it seems that that part is trying to open the package you saved when running through the import export data wizard, you have done this and opened the package it creates and not the blank package earlier on in the book
June 11, 2012 at 7:07 am
Yes, correct. It's the package I created during import/export exercise that I have imported.
I can see this if I look on DestinationConnectionOLEDB and SourceConnectionFlatFile. They both look fine.
June 11, 2012 at 7:17 am
I would say you have missed a step, I have just followed the steps and opened the packages and I see what the book says I should see.
I would go back and restart the chapter.
June 11, 2012 at 7:22 am
Yes.. possibly/probably.... I'll try a 3rd time.. from the beginning again. Not fun, but that's just the way it is.
Thank you so much for trying, really appreciate it!
June 11, 2012 at 10:12 am
To SSCrazy
Yes - 3rd time lucky! It seems like I had done something wrong when creating the package.
Thanks for helping me out.
June 12, 2012 at 1:25 am
Not a problem, hope you have fun with SSIS
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply