April 27, 2012 at 2:55 pm
I have tried using the SQL Server data import task to import from a .csv flat file that does an alright job but needs editing that the wizard does not allow, so I have saved it as an SSIS package in both the msdb location on my local version and again as a .dtsx file.
With SQL Management Studio, I can see the msdb package and right clicking it allows me to run it but there is no edit option. Using the VS BIDS system I can open the dtsx file and edit it to add features and modify others, but for some reason right-clicking on the Data Flow Task opens a pop-up that has no execute option preventing me from running it from there. What is it that I am missing?
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler
April 29, 2012 at 11:36 pm
Packages stored in the MSDB cannot be edited. The purpose is that only finished packages are stored there in orde to be scheduled by SQL Server Agent.
Regarding the dataflow error: is it possible to post a screenshot?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 30, 2012 at 6:03 am
Ron Kunce (4/27/2012)
... but for some reason right-clicking on the Data Flow Task opens a pop-up that has no execute option preventing me from running it from there. What is it that I am missing?
I am not an SSIS expert. But I think you cannot right click on a single task and run it.
You have to right click on the "package" and run it.
If you don't want any task to run, you can disable it.
Hope this helps you.
April 30, 2012 at 6:07 am
Suresh B. (4/30/2012)
Ron Kunce (4/27/2012)
... but for some reason right-clicking on the Data Flow Task opens a pop-up that has no execute option preventing me from running it from there. What is it that I am missing?I am not an SSIS expert. But I think you cannot right click on a single task and run it.
You have to right click on the "package" and run it.
If you don't want any task to run, you can disable it.
Hope this helps you.
Actually, you can.
The context menu will give you the option "Execute Task/Container", depending on the type.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 30, 2012 at 6:15 am
Koen Verbeeck (4/30/2012)
Actually, you can.The context menu will give you the option "Execute Task/Container", depending on the type.
Thanks Koen. I was not aware of it. I learned something new from you today 🙂
April 30, 2012 at 8:47 am
It does vary. In control flow, I can execute one task at a time. I cannot do that in Data Flow. I can execute the entire data flow from control flow, but not specific tasks within a data flow.
May 1, 2012 at 11:06 pm
herladygeekedness (4/30/2012)
It does vary. In control flow, I can execute one task at a time. I cannot do that in Data Flow. I can execute the entire data flow from control flow, but not specific tasks within a data flow.
That's because you can only execute tasks one at a time. An entire dataflow is exactly one task.
It wouldn't really make sense to execute only one component in a dataflow, as there would be no data flowing through.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply