Viewing 15 posts - 16 through 30 (of 58 total)
You can watch the progress of the child packages in BIDS if you set your Execute Package task to point to a local copy, which will open in BIDS during...
May 6, 2011 at 7:25 am
Yup - I've seen that.
Are you able to get that to work to /SET a configuration file when using dtexec? In testing, I can use that to work and...
May 5, 2011 at 2:42 pm
And, upon thinking about it, maybe this is where the confusion is between us lol ... Here's my definitions:
Design-time = working in BIDS, looking at the variables window, etc.
Run-time =...
May 5, 2011 at 2:18 pm
Try it (those MS links say exactly that: the design-time value will be re-loaded over a config file's value when using dtexec execution of a deployed package):
1. (in SSIS 2008)...
May 5, 2011 at 2:15 pm
Koen-
The issue in 2008 is that (refer to the MSDN link that I noted earlier) is in using configuration files. Here's the deal:
2005-
Running a dtexec command line that uses...
May 5, 2011 at 1:45 pm
Koen-
Based on your second reply to the original post, you wrote:
"if a variable in the dtsconfig file configure a variable that exists in the package, it certainly matters, as it...
May 5, 2011 at 12:39 pm
@Koen: learned this one after going through our SQL Server 2008R2 upgrade earlier this year ... all of our packages worked beautifully under 2005 with the xml files, but we...
May 5, 2011 at 8:19 am
Koen Verbeeck (5/3/2011)if a variable in the dtsconfig file configure a variable that exists in the package, it certainly matters, as it overrides the design time value.
This is not 100%...
May 5, 2011 at 8:16 am
An alternative to setting up a file connection and then dumping the variables is simply report the values in an email task to yourself (or, whoever needs to check the...
April 26, 2011 at 7:43 am
Though the approximate file size(s) wasn't noted, you're correct in that it'd be a waste for very large files; this is just a quick and dirty way to just grab...
April 19, 2011 at 12:26 pm
Another easy way to pull just header data is to do a conditional split off of the flat file source based on some sort of identifier in the header row...
April 19, 2011 at 8:09 am
Another possibility is to consider the use of source control software so you can make changes over time to local/checked-in packages and re-deploy them as-needed back out to msdb. ...
March 18, 2011 at 7:56 am
... or use the conversion component (it is there for a reason).
Probably the better choice: using the data conversion component more clearly shows what's happening in the data flow...
March 16, 2011 at 7:39 am
Koen Verbeeck (3/10/2011)
dg227 (3/10/2011)
Just a thought ... but bad data is still bad data if it's not sent to you in your established/spec format.
And you know what they say:
crap in...
March 10, 2011 at 12:17 pm
Building on the other suggestions and comments earlier in the thread, and if you're able to make file change requests, I'd recommend removing the text qualifier (so you don't get...
March 10, 2011 at 8:46 am
Viewing 15 posts - 16 through 30 (of 58 total)