Viewing 15 posts - 4,651 through 4,665 (of 7,164 total)
Why the Execute SQL Task? That will not help you efficiently load files from SSIS. Did you mean Data Flow Task?
Looping Through and Loading Files with SSIS
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 2, 2012 at 12:32 pm
Process all records how? Out to a flat file? Into another database? Please provide more detail about what you're trying to do. Also, posting your table definitions may help us...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 2, 2012 at 12:29 pm
You may not need to rig something like that up. What event are you waiting to see happen before your Script Tasks do work? Are you by chance polling for...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 2, 2012 at 12:27 pm
SQL Server 2005 Best Practices Analyzer
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 2, 2012 at 9:41 am
DB_Newbie2007 (4/2/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 2, 2012 at 8:44 am
Thanks for brightening this Monday morning GSquared 🙂
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 2, 2012 at 8:37 am
From the SQL Server 2005 documentation for sp_change_users_login
sp_change_users_login (Transact-SQL)
sp_change_users_login cannot be used with a SQL Server login created from a Windows principal or with a user created by using...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 2, 2012 at 12:54 am
OK, tables, yes, I was aware that you could select more than one table in the wizard but the OP was asking about flat files.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 2, 2012 at 12:34 am
Koen Verbeeck (4/1/2012)
Or the import/export wizard was used.
I did not know you could use the I/E Wizard to create more than one Data Flow task in a single package.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 2, 2012 at 12:29 am
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 31, 2012 at 8:56 am
Jeff Moden (3/31/2012)
opc.three (3/31/2012)
Jeff Moden (3/30/2012)
opc.three (3/30/2012)
It will actually do it properly, provided the commit size is 1
It's been a while but, IIRC, if you set MAXDOP to 1 and...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 31, 2012 at 8:49 am
PS I do not use BULK INSERT, but I am not finding any articles claiming MAXDOP 1 will have the desired effect. I am reading that TABLOCK may be part...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 31, 2012 at 6:21 am
Jeff Moden (3/30/2012)
opc.three (3/30/2012)
It will actually do it properly, provided the commit size is 1
It's been a while but, IIRC, if you set MAXDOP to 1 and you have no...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 31, 2012 at 5:28 am
Look, I wasn't there, and likely won't ever know what you were really up against, so I won't argue this point with you anymore. I am well aware of multiple...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 31, 2012 at 5:18 am
mohammed_suhan (3/30/2012)
Thanks alot for the suggestions.
The table already had identity column, SSIS inserts the data to this table every week. but it was not following the sequence which...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 30, 2012 at 9:53 pm
Viewing 15 posts - 4,651 through 4,665 (of 7,164 total)