Viewing 15 posts - 46 through 60 (of 107 total)
April 10, 2018 at 8:51 am
Thanks for your reply, Steve. We haven't upgraded SQL Server or BIDS versions, which is why the error was so puzzling. It has since then resolved itself somehow...very strange. In any...
April 10, 2018 at 8:44 am
Thanks, all for the replies. In brief, the reason I was trying to do this is to pull from a source field into a destination field for an SSIS package....
April 3, 2018 at 12:08 pm
I'm also experiencing this issue. Does anyone know why this would happen in one environment and not others? I was able to run parent packages fine in the Int environment,...
April 2, 2018 at 1:49 pm
Any suggestions are welcome....please?
March 20, 2018 at 10:08 am
Hi All,
I have a similar situation as the original poster's. I'm running a master SSIS package from a bat file, and per the last poster, I believe my...
March 2, 2018 at 1:32 pm
Does anyone know of a solution to this? I'm currently experiencing the same issue. Any advice would be greatly appreciated. Thanks!
February 26, 2018 at 2:40 pm
I just thought I'd post what ended up happening. I think somehow something somewhere got corrupted. So after talking to a colleague, I deleted the connection managers, and just copied...
February 23, 2018 at 8:37 am
So, I tried that, but it's still a no go, as the reference is still showing with the "could not be found" warning...:doze: ....I'm wondering if it needs to...
February 14, 2018 at 2:15 pm
Okay, thanks for the suggestion. I tried copying the Microsoft.SQLServer.ManagedDTS.dll file from the former location to the same location as the Microsoft.SqlServer.ScriptTask reference (C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Tasks), but it's...
February 14, 2018 at 1:40 pm
Okay, but I do have that reference installed, but it's giving me a warning saying it could not be found, even though I was able to add it from C:\Program...
February 14, 2018 at 1:05 pm
Sure...this is what's in the Script task:
using System;
February 14, 2018 at 12:37 pm
Hi Phil,
The script task basically loops through the multiple connection managers and ensures it's able to successfully connect to each. Any thoughts?
February 14, 2018 at 12:22 pm
Thanks, Patrick. I've posted my question on the integration services forum...I'm hoping I get some suggestions there.
February 14, 2018 at 12:08 pm
Thanks, Patrick....but I've tried adding the reference, "Microsoft.SqlServer.ManagedDTS" and I'm receiving a "The type or namespace name 'ManagedDTS' does not exist in the namespace 'Microsoft.SqlServer' (are you missing an assembly...
February 14, 2018 at 11:21 am
Viewing 15 posts - 46 through 60 (of 107 total)