Forum Replies Created
Viewing 15 posts - 2,311 through 2,325 (of 2,486 total)
-
RE: Breaking up a list into separate columns
So does the destination table just have those two fields?
If that's the case, it would probably be better if you import the data into a staging table. Then, using a...
-
RE: Breaking up a list into separate columns
quote:
... One of the columns is a list of names, sometimes empty, sometimes with one or more names separated by a comma.... -
RE: Passing the DataSource as a parameter to DTS
Put a ActiveXScript task in your package and add a MsgBox to echo what the connection settings are for the Excel file. That way you can be sure that the...
-
RE: SourceSafe and SQL Server 2000
Take a look at the following,
Versioning Stored procedures only
http://msdn.microsoft.com/library/default.asp?URL=/library/techart/sql7storprocvers.htm
SQL Source Control 2003, very promising product
http://www.skilledsoftware.com/
Good series of articles by Steve Jones
http://www.sqlservercentral.com/columnists/sjones/vcspart4.asp
My tool of choice for admins not developers
http://www.embarcadero.com/products/changemanager/index.asp
Hope this helps
Phill...
-
RE: Passing the DataSource as a parameter to DTS
Does the package execute successfully in Enterprise Manager? What version of SQL are you using?
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
-
RE: Log Space Usage of DTS
Check the indexing on the table you're inserting into. Check 'Optimizing Bulk Copy Performance' in books online.
If you export the data to a flat file, use Bulk Insert to import...
-
RE: Syntax Error For DTSRUN Command
quote:
In DTSRUN command, I have seen people using an encrypted package name. How do you do that? -
RE: Excel to Sql
Check the permissions for the account running the package.
When you run the package via xp_cmdshell and OLE Automation, the package is executing under the security context of the account the...
-
RE: Can DTS packages take a user-defined variable?
How does your package execute? If it executes interactively, you can use inputbox to request the parameters from the user.
If it's non-interactive, you could store the parameters in a table...
-
RE: Is There anyway to disable writing to Transaction
Check out "Logged and Minimally Logged Bulk Copy Operations" in BOL. It'll give you some tips on how to setup your server/database/procedure to have minimal logging.
Thanks
Phill Carter
--------------------
Colt 45 - the...
-
RE: Forum for contract help needed or something simila
Also you could include a section where people can leave feedback on the work completed. Like the feedback on eBay.
Thanks
Phill Carter
--------------------
Colt 45 - the original point and click interface
-
RE: AAAaaaargh! I said "COPY"...
If the field is varchar then you won't maintain any trailing spaces.
If the field is defined as char, any input is padded out to the length of the field.
eg: ABC[space][space]
in...
-
RE: AAAaaaargh! I said "COPY"...
What is the structure of the tables you are copying?
Thanks
Phill Carter
--------------------
Colt 45 - the original point and click interface
-
RE: Execute stored procedure from Transform Data Task
Another work around, If you specify the source as an SQL statement and define the transformations. Save the package. Then you can modify the source SQL statment to be a...
-
RE: DTS - How to check in destination table & filter
Where/How are you running the VB code?
Thanks
Phill Carter
--------------------
Colt 45 - the original point and click interface
Viewing 15 posts - 2,311 through 2,325 (of 2,486 total)