Viewing 15 posts - 1,081 through 1,095 (of 2,008 total)
ns22boss (12/6/2011)
Hi,I am using correct server and DB connections only...
How to check that we are using Correct DB connections and DB server.
Thanks
Please post your Java Connection String here.
December 6, 2011 at 4:55 am
Are you sure you are pointing to right Server & Database. Please verify your database connection in Java Console.
Easy test (assuming DEV environment): Delete all rows from Table (DB Connection)...
December 6, 2011 at 4:38 am
SQL Server stores datetime in YYYY-MM-DD hh:mm:ss[.fractional seconds] format. Rest all the formats are result of cast / convert functions and added operation on t-sql.
CAST and CONVERT (Transact-SQL)
December 5, 2011 at 9:47 am
SSIS Tutorial: Creating a Simple ETL Package
December 5, 2011 at 9:38 am
if the chain is broken,,, and when i enable the job,, i think i have to do is to re-initialize the backups and apply at the secondary.
To avoid it, I...
December 5, 2011 at 9:34 am
The error message says:
Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@BL".
Although it just points to @BL, I am sure if I remove @BL, then...
December 5, 2011 at 9:30 am
That is when you get into a pickle. 😀
Pickle as well as Tickle... :hehe:
December 5, 2011 at 9:20 am
SQLRNNR (12/5/2011)
Anybody else notice the changes to the blog section?
Where? :w00t:
December 5, 2011 at 9:10 am
Sean Lange (12/5/2011)
Dev (12/5/2011)
UTC_Time + UTC_Offset = LocalTime.
I have another equation. 😉
UTC_Time = LocalTime +/- UTC_Offset
The difference here is you are taking UTC as base where as I...
December 5, 2011 at 9:08 am
So basically, what you are telling me is that there is nothing, to your knowledge, that will automate this process, correct?
I am not sure. There are few guys who use...
December 5, 2011 at 9:01 am
IIRC, Export Import tool doesn't support FTP. You need to create a new SSIS package in BIDS.
December 5, 2011 at 8:46 am
UTC_Time + UTC_Offset = LocalTime.
I have another equation. 😉
UTC_Time = LocalTime +/- UTC_Offset
The difference here is you are taking UTC as base where as I am taking LocalTime as base...
December 5, 2011 at 8:43 am
Try SSIS. You will find all necessary tasks there you might need to perform on your files.
December 5, 2011 at 8:36 am
Are you doing it on PROD? It's not recommended.
Identify a test server and copy sample data (FULL is always better) on it. Create a test instance of your application &...
December 5, 2011 at 8:31 am
Gianluca Sartori (12/5/2011)
You could disable the constraints, check the data, delete invalid rows and enable the constraints again.
By disabling the constraint, you are allowing to enter bad data. Then it...
December 5, 2011 at 8:20 am
Viewing 15 posts - 1,081 through 1,095 (of 2,008 total)