Viewing 15 posts - 136 through 150 (of 150 total)
[font="Comic Sans MS"]This is an excellent question - and as usual I do not have answer to this . May I add a little more here to the question:
Can type...
[font="Comic Sans MS"]--
Sabya[/font]
November 23, 2009 at 3:02 pm
[font="Comic Sans MS"]You can have two execute sql tasks - one for success path and one for failure (from FTP task). These execute sql tasks will insert the required log...
[font="Comic Sans MS"]--
Sabya[/font]
November 20, 2009 at 5:59 pm
Can you please explain the scenario in detail?
[font="Comic Sans MS"]--
Sabya[/font]
November 20, 2009 at 9:47 am
Thanks Tim for the heads up. Yes - it was my wrong understanding of delimeter and text qualifier. As you suggested to doesn't matter if "" qualifier is not present...
[font="Comic Sans MS"]--
Sabya[/font]
November 20, 2009 at 8:00 am
The best possible online resource (other than BOL):
http://consultingblogs.emc.com/jamiethomson/
[font="Comic Sans MS"]--
Sabya[/font]
November 20, 2009 at 7:51 am
I think this can be done. But there should not be any dependency between the FTP job and the file creator job. That is - they should be asynchronous.
I assume...
[font="Comic Sans MS"]--
Sabya[/font]
November 19, 2009 at 1:49 pm
Tim,
Sorry I missed your reply somehow. I will check this out and let you know.
[font="Comic Sans MS"]--
Sabya[/font]
November 19, 2009 at 12:58 pm
Maybe it too let to acknowledge - but better late than never. Thank you - it worked.
[font="Comic Sans MS"]--
Sabya[/font]
November 19, 2009 at 12:46 pm
Yes - the Delay Validation property here needs to be set true. This will prevent the compiler to derive the value of the variable (here path/filename etc) till runtime and...
[font="Comic Sans MS"]--
Sabya[/font]
November 19, 2009 at 12:33 pm
Hi - one option could be something like this:
1) Declare a string variable (user::filename) within the scope.
2) Use a for each loop container to get the actual filename(as this is...
[font="Comic Sans MS"]--
Sabya[/font]
November 19, 2009 at 12:30 pm
Thanks guys 🙂
@tim-2 : It's not a business requirement - more of audit requirement that each load (identified by an unique loadId) would process only a single file...
[font="Comic Sans MS"]--
Sabya[/font]
November 12, 2009 at 7:59 am
Hi Tim/Others,
Similar problem here. I am on VS2005 and unable to open the sample packages.
My situation here is recordset with wrong delimeter: example
"AAA","BBB","CCC","","DDD",,"EEE
...
...
That is the 6th field comes as...
[font="Comic Sans MS"]--
Sabya[/font]
November 2, 2009 at 10:46 am
Thank you Andy - will try this out ...
[font="Comic Sans MS"]--
Sabya[/font]
August 30, 2009 at 12:26 am
Any help on this guys ...
[font="Comic Sans MS"]--
Sabya[/font]
April 14, 2009 at 3:49 am
Which data modeling tool are you using? Use any good tool like ERWIN and use option of forward engineering to get your database creation script. The reverse option is available...
[font="Comic Sans MS"]--
Sabya[/font]
August 4, 2008 at 3:09 am
Viewing 15 posts - 136 through 150 (of 150 total)