Viewing 15 posts - 46 through 60 (of 108 total)
vipin_jha123 (5/21/2015)
Hi ,Sample data are below :-
06/06/63
09/17/61
06/03/69
11/23/64
07/10/90
02/02/69
09/30/70
12/05/49
01/04/67
Regards,
Vipin jha
If this the sample data after conversion, then while loading in SSIS it will consider these dates as invalid because the middle value...
____________________________________________________________
APMay 21, 2015 at 5:31 am
vipin_jha123 (5/21/2015)
Hi ,Sample data are below :-
06/06/63
If this is the source data, then for sure your conversion will fail. Did you even try to execute your CASE statement in SQL?...
____________________________________________________________
APMay 21, 2015 at 5:20 am
Please share some sample data you have in this column.
____________________________________________________________
APMay 21, 2015 at 2:31 am
record 1, 2, 3, is good for me, but i would to check situation like record 4 because Dt1 from record 4 is inside dt1 - dt2 record 3
And dt1...
____________________________________________________________
APMay 19, 2015 at 5:22 am
Add check constraint to your table.
https://msdn.microsoft.com/en-IN/library/ms190377.aspx
____________________________________________________________
APMay 19, 2015 at 4:26 am
I am surprised with your query.
If you are inserting something in your table, then how come you can use same column name in the select query?
Still..
You are inserting "(dateadd(day, -1,...
____________________________________________________________
APMay 19, 2015 at 12:22 am
this builds and fails the ssis package if the != is true.
Look right to you, Anshul?
Looks fine to me.
Cheers.
____________________________________________________________
APMay 18, 2015 at 10:03 pm
public void Main()
{
// TODO: Add your code here
...
____________________________________________________________
APMay 17, 2015 at 10:02 pm
You can use HASHBYTES.
https://msdn.microsoft.com/en-IN/library/ms174415.aspx
____________________________________________________________
APMay 15, 2015 at 2:08 am
Makes sense...Cheers!!
____________________________________________________________
APMay 14, 2015 at 9:12 pm
Get SQL Agent permission first. Then you can create a SQL job to schedule your SSIS package.
____________________________________________________________
APMay 14, 2015 at 9:10 pm
polkadot (5/14/2015)
Right now IF any of those pair aren't equal the package just stops running, which...
____________________________________________________________
APMay 14, 2015 at 9:07 pm
PJ_SQL (5/12/2015)
I am using FTP Connection manager in SSIS to upload files. Does it close session after it completes the task?
Yes, it does. On completion, it will close the session.
____________________________________________________________
APMay 14, 2015 at 5:15 am
If you are sure your source data is unique then First Load data into your table and then create clustered index on it. It would be faster.
____________________________________________________________
APMay 14, 2015 at 5:09 am
Verify once again, it must be having two variables with the same name.
Example - One at the package level and another at the task level. So, in case you...
____________________________________________________________
APMay 14, 2015 at 4:05 am
Viewing 15 posts - 46 through 60 (of 108 total)