Viewing 13 posts - 1 through 13 (of 13 total)
Hi all, thank you for your replies I appreciate the ideas and suggestions greatly. I'll do my best to provide all the info I've got (and be clear to say...
February 9, 2017 at 8:02 pm
I suspect, if its not a bug (which seems all but assured), then its got something to do with db (updates), but there ar no updates occurring in this script.
I...
March 3, 2015 at 12:23 pm
thanks folks for the ideas. Remember the issue is intermittent. I've run the script 3 or 4 times since yesterday and no dups. but i have bak from when...
March 3, 2015 at 10:43 am
Ok, this is something I haven't done before.
Since the problem is intermittent, I can't run the ADODB recordset selection stmt twice. One set may or may not contain...
March 3, 2015 at 9:01 am
Hi,
I agree. I have nothing concrete on it being the culprit. Its a best analysis opinion after reviewing the script. I'm setting up the script to take...
March 3, 2015 at 8:11 am
And the DumbAxx award of the week goes to.....Me! the global parameter was typed as a string. Correct. But the delimiters on that string, apparently, are not required.
Thanks everyone,...
November 5, 2013 at 3:10 pm
I don't remember exactly what it was -- it may have bben a rights issue elsewhere.
Heres the string I used:
"Provider=SQLOLEDB.1;Server=<sn>;Integrated Security=SSPI;Persist Security Info=False;User ID=<sqlid>;password=<sqlidpw>;use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Initial Catalog=<dbname>;Data...
March 19, 2010 at 11:40 am
thanks folks for all your help,
I'm going the scripting route as you suggest. I'm most familiar with that and need some productivity gain compared to the last few days.
I found...
March 18, 2010 at 9:36 am
Sorry, never mind that last bit about For each and Foreach -- I mis-read For Loop and For each loop
March 17, 2010 at 8:59 am
I found this:
http://blogs.msdn.com/luti/archive/2008/07/11/ssis-by-example-1-processing-files-in-folder.aspx
it seems to summarize everything into one process.
though having trouble with the user::filepath not providing a file name to the flat file connection when the foreach...
March 17, 2010 at 8:48 am
All right, more info:
If I use the migration wizard and proceed as described above. I get a log ,but can't find an entry in any drilldown or search of the...
March 6, 2010 at 6:35 pm
This issue is resolved (at least for _use__) if not why.
I found that using [servername].[dbname].[dbo].bc20100... avoided errors
ie _really_ telling SQL where to go. Which is strange because the connection...
March 6, 2010 at 5:55 pm
Wow, thanks for the links/ pointers all. Been implementing other parts of this system and finally got back here. I haven't had a chance to digest or delve into...
March 4, 2010 at 8:14 am
Viewing 13 posts - 1 through 13 (of 13 total)