Viewing 15 posts - 106 through 120 (of 322 total)
ulile (9/18/2008)
Did you ever try to solve the problem with a Stored Procedure ?
Do you mean skip SSIS completely? That might be attractive.
September 18, 2008 at 5:29 am
Sergie:
Interesting that with the "WITH SCHEMABINDING" clause removed, the return is 0 = Not Deterministic. I guess I don't understand why that has anything to do with it. Is...
September 18, 2008 at 4:49 am
I don't understand -- if you wind up with a copy of their .mdb file where your SQL Server can reach it, does it matter how it got there (FTP,...
September 17, 2008 at 5:53 am
Any reason why you would not be able to simply define the .mdb database as a linked server, and query it directly? So long as the file location, name, and...
September 17, 2008 at 4:39 am
I think you may be on to the problem. The "dummy" Excel file needs to match (and probably should be) one of the actual input files you expect to...
September 17, 2008 at 4:19 am
FWIW - I noted a reference to @today (or something) earlier in your comments. I have been bit big time by T-SQL deciding that a time variable (e.g. from...
September 16, 2008 at 6:29 am
Check BOL under "Extended Properties [SQL Server]. I have no idea why it takes SSMS so long to add an extended property to a column, but you can do it...
September 16, 2008 at 6:09 am
I have used (after a struggle) ForEach loops, variables,and expressions, with some success for things like dynamic Excel workbook and worksheet names. But what I need now is a...
September 16, 2008 at 4:53 am
Jo Pattyn (1/20/2006)
second step: caused by issue: data grows beyond 2 gb & needs to be accessible through WAN
The 2GB Access "limit" is something of a red herring. You can...
September 12, 2008 at 5:31 am
The Google Site Search. I guess that's my problem.
(And now I see the "My Posts" link, which I couldn't find when I wanted it. Thanks!)
September 11, 2008 at 11:01 am
Maybe I am trying to find an automated approach too soon. Hell, I have been totaly unable to even do it by hand with a Flat File Data Source and...
September 11, 2008 at 10:06 am
Welcome to the world of SSIS! Since you are still grasping at straws, I'll throw out a couple of more (still based on my own lack of understanding):
1. Does your...
September 5, 2008 at 9:09 am
Terry Phelps (9/5/2008)
... but found significantly more information on this topic browsing various web sites.
How true -- If I had a Google account, it would have been overdrawn since I...
September 5, 2008 at 5:22 am
A couple of random thoughts (in case it is not working yet--guesswork follows):
1. In the Foreach Loop Editor/Collection, use "Retrieve file name" = 'Name only".
2. In your script statement" "sFolder...
September 5, 2008 at 4:41 am
I bought "Professional SQL Server 2005 Integration Services" and have not found it as helpful (as a reference) as I had hoped. Brian Knight is a real knowledgable guy (I...
September 4, 2008 at 5:01 am
Viewing 15 posts - 106 through 120 (of 322 total)