Forum Replies Created
Viewing 12 posts - 1 through 12 (of 12 total)
-
RE: programming a dts package
Well, yes, but the problem is that I have to do all that from code (C#). There is no problem while creating the package in designer - that works just...
-
RE: programming a dts package
Ok, now... I got into the problem a bit more... Now I'm building the dts from scratch... The goal is to build a dts to export some data (sql statement...
-
RE: programming a dts package
dmbaker, thanks, that worked just fine
Who would've thought that it's a bug in DTS.... Shouldn't there be a patch or service pack for... -
RE: programming a dts package
The code is this:
try
{
Package2Class package = new Package2Class();
Object pVarPersistStgOfHost = null;
package.LoadFromStorageFile(
-
RE: programming a dts package
Actually, my question is this (I narrowed it down a bit): I have a DTS package created in SQL, and I defined global variables on Data source, initial catalog etc....
-
RE: exec sp_ExecuteSql... ???
Thanks a million, Ryan
That solved all of my troubles!!! You really made my day!
-
RE: Excel and SQL
Well, Prakash, after pondering what to do, I also came to the conclusion that the best way is to use the temp table, only with a slight change. I used...
-
RE: Excel and SQL
John,
no, it will not work for me
I have to automatize this operation, so I could perform this operation as a job in... -
RE: Error 446 - help!
Well, Martin, thank you VEEERYYY much! Your information has been most helpful. I'll look into the matter.
Thanks again!
-
RE: Error 446 - help!
I was wrong, Martin.
User dbs don't have the same collation as master db. master db's collation is SQL_Latin1_General_CP1251_CS_AS, and user dbs are CI.
I am totaly confused ...
-
RE: Error 446 - help!
Well, there you have it - user dbs have the same collation as master. I would also say that there's some kind of mistake involved, because no one has issued an...
-
RE: Error 446 - help!
You are right, here are the results:
select databasepropertyex('master','collation')
- SQL_Latin1_General_CP1251_CS_AS
select databasepropertyex('model','collation')
- SQL_Latin1_General_CP1_CI_AS
select databasepropertyex('tempdb','collation')
-SQL_Latin1_General_CP1_CI_AS
But what does that mean? What exactly is collation? And what am I supposed to do?
Thanx
Viewing 12 posts - 1 through 12 (of 12 total)