Viewing 15 posts - 721 through 735 (of 893 total)
November 21, 2011 at 8:12 am
Have a look at the following, and see if it explains it well enough...otherwise I can have another look: http://microsoft-ssis.blogspot.com/2011/02/how-to-configure-foreach-loop-file.html
November 21, 2011 at 8:10 am
Yeah...tough situation.
I think no. 3 would be your most sustainable option in the current setup. Sure, creating a hundred empty files is a lot of work but not as much...
November 18, 2011 at 11:33 am
Debbie Edwards (11/18/2011)
So is the above not possible? Setting the parameters at the top level for...
November 18, 2011 at 9:03 am
Debbie Edwards (11/18/2011)
A top level package which runs the package with the SPs in
Set the parameters up at this level
Delete...
November 18, 2011 at 8:40 am
Unfortunately I don't have the environments available to test this further, but here are a few suggestions to eliminate the error. All of these would require some work on your...
November 18, 2011 at 7:14 am
Jeff Moden (11/17/2011)
kevin_nikolai (11/17/2011)
Hi Komal,Martins method: DWH.dbo.Split_Values(@Store_Code_List,',') should be used in stored proc's where clause (not in from clause).
Sorry, but no. Martin's method uses a WHILE loop and an...
November 18, 2011 at 6:47 am
That symbol looks like a carriage return to me...and it would make sense that SSIS inserts that at the end of the line.
November 18, 2011 at 6:42 am
David Data (11/17/2011)
Thanks Martin - but having looked there, I can't see any changes that affect how SSIS deals with the NUL device.
We'll need more information to help you then....
November 17, 2011 at 3:51 pm
quillis131 (11/17/2011)
Martin Schoombee (11/17/2011)
Do you know the ascii code for it?Not sure about the ascil code, Looking forward to get Rightward arrow (?)
If you find out what the ascii code...
November 17, 2011 at 11:56 am
Are you talking about the SCD component in SSIS? Why don't you give it a try...create a test package and see if it is possible to delete records. Or read...
November 17, 2011 at 10:57 am
Do you know the ascii code for it?
November 17, 2011 at 10:53 am
battery_acid_h (11/17/2011)
Anyone experienced this:, no data shows up on my report...
I created a query from an SSAS cube, the data displays in the query. I added the fields to my...
November 17, 2011 at 10:50 am
Just a quick observation:
The "GROUP BY" and "HAVING" clauses should only be used when you have aggregate functions in your query. Not too sure why you have both in query...
November 17, 2011 at 10:42 am
Not too sure, but for a list of bug fixes in SP3 you can have a look here: http://support.microsoft.com/kb/2546945
November 17, 2011 at 10:32 am
Viewing 15 posts - 721 through 735 (of 893 total)