Viewing 15 posts - 3,676 through 3,690 (of 3,738 total)
Have you tried using a format file with the BCP Utility?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 3, 2010 at 11:23 am
You need to change the delimeter so that it does not import the "".
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 3, 2010 at 11:18 am
I have experienced issues with a 64 Bit Server.
What task(s) are hanging and what processes do they use?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 3, 2010 at 11:07 am
Are you using VSS?
http://www.opcg.com/index.php/2009/03/17/visual-studio-the-selected-file-is-not-a-2005?blog=2
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 3, 2010 at 10:11 am
If you want all of the records of the Date Column to contain the exact same value for each date imnported then you could define a variable in the SQL...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 3, 2010 at 9:41 am
Sounds like you need to store the value of the column that identifies what records to update in a package variable and then use variabole as an input parameter in...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 3, 2010 at 8:12 am
You should add the column to the table.
You may want to add two columns, one to store the Date the File Created and another to store the Date Modified of...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 3, 2010 at 7:42 am
Typically you would have a @MaxCounter or a hard code value.
I believe that you want to assign @Counter = 1.
The send mail task may not work for you.
I have used...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 3, 2010 at 7:36 am
Sorry for any confusion.
The important thing is that you check the system tables to determine if the index exists. I mentioned this in a couple of post earlier today but...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 3, 2010 at 7:26 am
Have you looked at the send mail task?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 3, 2010 at 7:21 am
Create a Package Level Expression @Counter
Set the INtail Value to Zero
Right click on the For Loop COntainer and Choose Edit
Set the InitCount = @Counter
Set the AssignExpression Property to @Counter =...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 3, 2010 at 7:17 am
You could use an Expression that is Counter for each file and is updated for each file that is read.
Then refer to the expression's value when you generate the e-mail.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 3, 2010 at 7:06 am
If you decide not to use the BCP Utility which has it's advantages you may want to consider using the SSIS Import and Export Wizard.
One way to access this...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 3, 2010 at 7:01 am
Oracle using the same concept as the later versions of SQL Server.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 3, 2010 at 6:34 am
Please rtefer to the following link:
http://www.cryer.co.uk/brian/oracle/howto_orcl_rbai.htm
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 3, 2010 at 5:53 am
Viewing 15 posts - 3,676 through 3,690 (of 3,738 total)