Viewing 15 posts - 16 through 30 (of 150 total)
[font="Comic Sans MS"]
Can you be more specific on the workflow? Are you using sql query/sp anywhere or integration service components all the way?
[/font]
June 16, 2010 at 7:27 am
[font="Comic Sans MS"]
Are you sure the connection being resolved properly and the statement is being executed at all? You can see the progress of the particular component and get an...
June 16, 2010 at 7:19 am
[font="Comic Sans MS"]
Alternatively - you can send the output to a flatfile destination (a comma separated file) and mail the file as an attachment.
[/font]
February 25, 2010 at 7:51 am
[font="Comic Sans MS"]
Just in case someone needs this - it a simple join but took a while for me to find the tables. Also query this uses old 2000 system...
February 19, 2010 at 8:10 am
[font="Comic Sans MS"]
Sorry Jibbara - I tired to go through the the statement few times and got lost somehow. Probably my bad ..
Could you try to elaborate with some data...
February 18, 2010 at 9:32 am
[font="Comic Sans MS"]
Yes ... I am using 3 level of package hierarchy and performancewise it has been absolutely fine...
[/font]
February 18, 2010 at 9:24 am
[font="Comic Sans MS"]
Yes - you can actually run this. Also this is the reason I asked if you have tried the approach at all. I bothered to write hoping you...
February 2, 2010 at 5:47 pm
[font="Comic Sans MS"]
Did you at least try?
[/font]
February 1, 2010 at 4:41 pm
[font="Comic Sans MS"]
This is strange. I am stuck here too - came across this codeplex project and very much interested to try this out.
After importing a simple package - I...
January 21, 2010 at 10:03 am
[font="Comic Sans MS"]
You can use forEachLoop container for this. Assign the enumerated value of the field to an user defined SSIS variable - generate the recordset using the query -...
January 19, 2010 at 8:12 am
[font="Comic Sans MS"]
You can use conditional split to limit the recordset.
If you are using any surrogate key - like starting from 1..3000000 .. you can use that
or you have...
January 19, 2010 at 8:04 am
[font="Comic Sans MS"]
Sorry - I am unable understand the problem you are facing here.
Are you looking forward to optimize your Exec SQL task?
If yes - how long does it take...
January 18, 2010 at 1:49 pm
[font="Comic Sans MS"]
Here is a quick and excellent reference :
http://www.sqlis.com/post/The-Execute-SQL-Task.aspx
[/font]
January 18, 2010 at 1:43 pm
[font="Comic Sans MS"]
CSV files are for tabular representation of data - not for text highlighting. It's equivalent of : select * from tablename ...
If you need your data to...
January 18, 2010 at 1:41 pm
[font="Comic Sans MS"]
wildcard *.csv should work.
Please have a look at the link below and see if you are doing something wrong.
http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx
[/font]
January 15, 2010 at 2:01 pm
Viewing 15 posts - 16 through 30 (of 150 total)