Viewing 15 posts - 8,566 through 8,580 (of 11,678 total)
ahmed_b72 (12/12/2011)
Hi Koen,Thanks for making it clear like crystal to me.
No problem, glad to help.
December 12, 2011 at 11:27 pm
Elliott Whitlow (12/12/2011)
December 12, 2011 at 11:26 pm
LS-487884 (12/12/2011)
No, there is no lock on the file. It seems like a really fluky issue.
What happens if you step through the script with the debugger?
December 12, 2011 at 11:24 pm
SQLRNNR (12/12/2011)
That would only be evidence if he became a MySQL, Firebird, NoSQL, PostGres, Informix or Oracle DBA.
Brrrr... Oracle.
I spent 4 hours yesterday setting up an Oracle client on the...
December 12, 2011 at 11:20 pm
Charmer (12/12/2011)
Koen Verbeeck (12/12/2011)
Charmer (12/12/2011)
Koen Verbeeck (12/12/2011)
The only thing you need to do is change the connection manager for the log provider...
December 12, 2011 at 11:16 pm
Charmer (12/12/2011)
Koen Verbeeck (12/12/2011)
The only thing you need to do is change the connection manager for the log provider each time you...
December 12, 2011 at 7:38 am
John Mitchell-245523 (12/12/2011)
ashanair70 (12/12/2011)
Is there a link or write-up that I can refer to do this?
I searched the internet for "create solution in bids". If you do the same,...
December 12, 2011 at 7:32 am
You can use the standard built-in logging for that.
The only thing you need to do is change the connection manager for the log provider each time you run the package,...
December 12, 2011 at 6:04 am
You need to add the package to an SSIS solution in BIDS in order to debug it.
December 12, 2011 at 5:59 am
Elliott Whitlow (12/9/2011)
I would use a data-flow task. The rows are generated by a source and a script...
December 12, 2011 at 3:21 am
Welsh Corgi (12/9/2011)
I had to change the Debug Option 64bitRuntime to False.
You should also do that when you are not using CozyRoc but regular SSIS tasks dealing with Excel.
Doesn't have...
December 12, 2011 at 3:18 am
There isn't a lock on the file or something like that?
December 12, 2011 at 3:16 am
OK, disregard my question about the connection manager. It is not pointed at a dbf file, but at the folder that has those dbf files.
Regarding the error:
you probably get that...
December 12, 2011 at 2:23 am
You need to run the package that contains the Cache Transform to refresh the cache.
http://blogs.msdn.com/b/mattm/archive/2008/11/22/lookup-using-the-cache-connection-manager.aspx
Make sure you also read the references at the bottom of the article.
December 12, 2011 at 2:16 am
Reading the flat file can be done using a flat file connection manager and a flat file source.
Adding a blank column can easily be done with the derived column.
If the...
December 12, 2011 at 2:13 am
Viewing 15 posts - 8,566 through 8,580 (of 11,678 total)