Viewing 15 posts - 3,106 through 3,120 (of 13,855 total)
I'm sorry, but I don't know how to write it any more clearly. To summarise:
November 26, 2019 at 5:58 pm
Don't you just love it when you get a "urgent" work request that needs to be done "NOW", because it's impacting staff productivity, so you get the work done...
November 26, 2019 at 2:51 pm
Just to elaborate, if you set up the other packages to run within a master package, you can then pass the variables that way. If you're using SQL Server...
November 26, 2019 at 2:18 pm
What do you mean by 'copy'? Where to? Where from? Using what tool?
November 26, 2019 at 1:45 pm
Seems like the spam is ramping up again.
November 26, 2019 at 12:01 pm
Please reread my post. I said use an Expression task to set the value of a variable. Once set in this way, the value will remain static.
November 25, 2019 at 9:59 pm
Sure. Create a string variable and use an Expression task to set its value (using the code you pasted).
The rename and move can then reference the variable.
November 25, 2019 at 9:12 pm
No. Only parameters can be shared, and only within a project (not across a solution).
November 25, 2019 at 6:44 pm
How are you deploying your packages to the server? Are you using the project deployment model? If not, I suggest that you consider upgrading to it.
Please read here for...
November 25, 2019 at 6:42 pm
I was able to reproduce this error. Have you had success setting this property by Expression in the past? Perhaps this is a property which cannot be parameterised ...
November 25, 2019 at 5:19 pm
I've just been through this pain too ... VS2017 and still no easy way to re-order columns in a destination file.
Creating a blank file in the required format (just headers)...
November 25, 2019 at 4:44 pm
when i ran the package through sql agent job it got failed but i did not find any information in job history
Executed as user: . Started: 11:59:55 AM Finished:...
November 25, 2019 at 1:52 pm
You might want to use a script to update your variable values rather than use an expression since you are updating every time the package is run.
If the logic...
November 22, 2019 at 12:26 pm
When packages run, they cannot update themselves, so a wholly package-based solution is not the way ahead.
However, your package can read from and write to a metadata table inside a...
November 21, 2019 at 6:51 pm
I just reread your original post a little more closely. Your duplicates are in the source, not in the target, is that correct?
If so, the best way of handling this...
November 21, 2019 at 6:47 pm
Viewing 15 posts - 3,106 through 3,120 (of 13,855 total)