February 23, 2012 at 11:32 am
Hi all.
I have an SSIS package that loops through a list of servers and runs some sql...
Using a server name variable, the server name gets passed to my connection manager in a foreach loop container. Inside the container is a sql task. The Connection Manager's Server name field is left blank. I now want to modify the sql that gets executed in the sql task but can't modify it because when I click ok it tries to validate the sql and can't connect to the Server because the Server name is blank in the connection manager. Is there any way to get around the sql validation in the designer?
Thanks for all replies.
February 23, 2012 at 12:26 pm
To avoid assuming, I'll ask: Have you set the Delay Validation property on the package and the query object to True?
Also, can you provide it with a "temporary" server name while you're editing it, but that gets replaced by the variable at runtime?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply