Viewing 15 posts - 3,016 through 3,030 (of 3,738 total)
You can skip but if you can get the file with the column names and without a header.
In my opinion it makes it easier if you have the column names...
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/
May 19, 2011 at 9:02 am
richarddelcarmen (5/18/2011)
There are miscellaneous information in the first 10 lines like the date the file was created, the title of the report, etc.The column headers starts in line 11.
How is...
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/
May 18, 2011 at 7:24 pm
How long does it take before you get this error?
Do smaller and/or larger files get loaded?
Are the files stored on the same subnet?
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/
May 18, 2011 at 4:46 pm
If you specify a DB ID and Text Data then it is going to filter by both criteria.
For the Database ID you could use a combination of Greater Than or...
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/
May 18, 2011 at 4:36 pm
Does this happen with all tables?
Is it always slow or jut during peak times?
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/
May 18, 2011 at 4:02 pm
david.richard (5/18/2011)
Is there any problem with having 2 or more NIC's with IP addresses on completely different networks on the same instance of SQL server 2008 but separate databases?
Why do...
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/
May 18, 2011 at 3:56 pm
ArtJC (5/18/2011)
Can you provide me with any examples of script task to do this. I am not very experienced with vb coding
Dts.Variables("gsFileName").Value = sFilePath & sFilePrefix & sDateTimeStamp & sFileSuffix
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/
May 18, 2011 at 2:23 pm
ddnikon (5/18/2011)
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/
May 18, 2011 at 2:18 pm
It is relatively easy to do in a script 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/
May 18, 2011 at 1:55 pm
Have you checked the properties on the Execute Package Task?
I assume that you have a precedent constraint define as on success?
When you execute the package in Design mode does it...
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/
May 18, 2011 at 1:46 pm
What do you mean there is a bunch of text in the upper part of the file?
How is the csv being created? The csv needs to be created or saved...
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/
May 18, 2011 at 1:42 pm
sounds like you wanto to Concatenate SSIS Variables?
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/
May 18, 2011 at 1:26 pm
Chrissy321 (5/18/2011)
Doesn't BCP require xp_cmdshell to call it?
You can use BCP with Powershell.
http://stackoverflow.com/questions/2479434/run-a-shell-command-with-arguments-from-powershell-script
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/
May 18, 2011 at 10:30 am
daveriya (5/18/2011)
so the package is like this
initialize->creates new archive directory (with timestamp)
-> given 2 condition
like findstring("user::find_spec","|",1)==0
findstring("user::find_spec","|",1)!=0
after that there is a archive...
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/
May 18, 2011 at 10:08 am
The following article may give you some information and help you make your case.
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/
May 18, 2011 at 9:11 am
Viewing 15 posts - 3,016 through 3,030 (of 3,738 total)