Viewing 8 posts - 16 through 23 (of 23 total)
Okay so then for calculating how much space a non-null record will take it would be 16bytes + len of the text field as a rough estimate?
the point...
July 20, 2009 at 1:39 pm
Worked much better with 2005, no issues at all with converting data types.
And finally found the setting that I had missed for getting it to work with SQL 2000. ...
April 29, 2009 at 12:55 pm
so after a bit more digging it looks like I am able to replicate most of what I need. But UDT's are so far still causing me issues. ...
April 28, 2009 at 7:29 pm
No this box doesn't have service pack 4. Will have to look into that.
October 14, 2008 at 11:41 am
I finally figured out what was causing this error. On the collection page of the Foreach Loop Editor, in the retrieve file name section, I had for some reason...
October 1, 2008 at 8:52 am
I looked through that link, added in some logging which I hadn't been doing before and this is what I get.
PackageStart,********,********,********,{83D9CA85-F329-42F1-83B6-7DB9B53F7785},{EF6ADB1F-7B4A-4932-BE63-039FC9421FAA},9/30/2008 1:20:03 PM,9/30/2008 1:20:03 PM,0,0x,Beginning of package execution.
Diagnostic,********,********,********,{83D9CA85-F329-42F1-83B6-7DB9B53F7785},{EF6ADB1F-7B4A-4932-BE63-039FC9421FAA},9/30/2008 1:20:03 PM,9/30/2008...
September 30, 2008 at 11:32 am
ramu4ind (9/30/2008)
You need to give correct path in the variable and that variable can be use in the connection as expression.I think it helps
in the properties for the flat file...
September 30, 2008 at 8:03 am
I have made sure that I granted SQL Server Agent full access to this folder but I am still getting this error.
as for how I run this. ...
September 30, 2008 at 7:57 am
Viewing 8 posts - 16 through 23 (of 23 total)