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...
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...
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?
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...
May 18, 2011 at 4:36 pm
Does this happen with all tables?
Is it always slow or jut during peak times?
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...
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
May 18, 2011 at 2:23 pm
ddnikon (5/18/2011)
May 18, 2011 at 2:18 pm
It is relatively easy to do in a script task.
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...
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...
May 18, 2011 at 1:42 pm
sounds like you wanto to Concatenate SSIS Variables?
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
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...
May 18, 2011 at 10:08 am
The following article may give you some information and help you make your case.
May 18, 2011 at 9:11 am
Viewing 15 posts - 3,016 through 3,030 (of 3,738 total)