Viewing 15 posts - 5,371 through 5,385 (of 19,560 total)
Check the permissions on the path and validate that the path is correct (file names included). Also make sure the files have been copied to the same path location...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 3, 2013 at 9:15 am
JAZZ Master (1/3/2013)
SGT_squeequal (1/2/2013)
crookj (1/2/2013)
Daniel Bowlin (1/2/2013)
In the immortal words of Uniblab"Back to work (click), back to work (click). Everybody ( click) work, work, work, work (click), work, work (click)."
In...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 3, 2013 at 9:12 am
Tbmabry, did this post by dwain help you?
dwain.c (1/2/2013)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 3, 2013 at 8:55 am
In that case I would most likely replicate those two tables.
But since you insist on using SSIS, you can create an agent job and then put a trigger on those...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 2, 2013 at 10:47 pm
jon.spain (1/2/2013)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 2, 2013 at 10:41 pm
Thanks for the question.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 2, 2013 at 10:36 pm
From what you describe I would say SSIS is the wrong technology to use for your needs.
It appears that you need replication or logshipping and not SSIS.
Can you clarify your...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 2, 2013 at 10:32 pm
Steve Jones - SSC Editor (1/2/2013)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 2, 2013 at 10:29 pm
I have used several VPN clients and have had no issues. What VPN software are you using? Have you checked with your IT team to determine if they...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 2, 2013 at 9:09 pm
RamSteve (1/2/2013)
I will not be expecting any other parameters ..Only i do have only 6 parameters in where Clause
So of the 9 parameters you listed, which 6 are possible? ...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 2, 2013 at 7:08 pm
Other than Case 6, do you expect to have the ability to have multiple conditions in the where clause?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 2, 2013 at 6:40 pm
It looks like you have some data that does not meet the requirements (an invalid email address or the @ symbol is present without an email address).
Can you provide sample...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 2, 2013 at 6:37 pm
You cannot deploy a 2012 package to SQL Server 2005.
However, you can use SQL Server 2005 in your connection manager. But the package must be run from SQL 2012.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 2, 2013 at 10:09 am
Steve Jones - SSC Editor (1/2/2013)
SQLRNNR (1/2/2013)
Steve Jones - SSC Editor (1/2/2013)
Happy New Year everyone, and welcome back to work.You didn't need to spoil it like that ;-):-D:hehe:
If I have...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 2, 2013 at 10:02 am
Nice discussion going on here.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 2, 2013 at 9:55 am
Viewing 15 posts - 5,371 through 5,385 (of 19,560 total)