Viewing 15 posts - 2,086 through 2,100 (of 13,855 total)
This is not particularly elegant, but it seems to get the job done.
Next time, please remember to post your sample data in consumable format, so that others can simply paste...
April 26, 2021 at 6:31 pm
As I suggested in one of your other threads, SSIS needs to 'see' the table it is going to load data into at design time, not at run time.
Do the...
April 26, 2021 at 12:01 pm
Here are the results of the queries you provided. Now tell us what the logic is to get from here to the results you require, as it is not clear...
April 26, 2021 at 9:49 am
Yes, I can complete thos process easily when i do it within a TSQL DB, but this is giving me errors in thise case, data types differences.
Use an...
April 26, 2021 at 8:01 am
Assuming your target column's datatype is 'DATE', it does not have a display format.
If your import is converting formats from DDMM to MMDD, you would get lots of errors for...
April 26, 2021 at 7:59 am
There is something strange going on here.
Are you trying to create a table within a data flow? (I see a Mappings node)
April 25, 2021 at 9:27 am
A more refined alternative, which does not run the risk of losing rows through aggregation:
SELECT t.Field0
,t.Field1
...
April 23, 2021 at 7:19 am
Another alternative
SELECT Field0
,Field1
,Field2
,Field3
,Field4...
April 23, 2021 at 6:36 am
Any thoughts on how can we accomplish this?
None whatsoever. You haven't provided DDL, sample data in the form of INSERT statements and desired output based on your sample data, nor...
April 22, 2021 at 3:06 pm
I solved the above by simply changing the datatype in SQL Server table to NVARCHAR... again thanks for all the help!
Well done, but for future reference note that...
April 20, 2021 at 5:42 pm
By 'betting', did you mean 'better'?
WinSCP is actually a rather good solution.
But if, by better, you meant easier to configure, I'd recommend this: https://www.cozyroc.com/ssis/file-transfer-task.
It's not free, but works well...
April 20, 2021 at 5:34 pm
Also if I wanted to pass a literal string to a SQL field via SSIS do I just add another variable and assign the literal value to pass...
April 20, 2021 at 4:40 pm
(DT_DATE) should do the job.
April 20, 2021 at 4:29 pm
One more thing I changed my expression to (DT_Date)(LEFT(RIGHT(@[User::FileNameDate],14),10)) to convert to a date but it returns format like: 3/31/2021 (?) Are there other ways to convert the...
April 20, 2021 at 4:00 pm
Considering you said earlier:
The file names are always in this format: "ConvoEVQ2021-04-05"
Assuming that there is no extension, what's wrong left LEFT(User::FileNameVariable,10)? For the above that'll be 2021-04-05. You...
April 20, 2021 at 9:36 am
Viewing 15 posts - 2,086 through 2,100 (of 13,855 total)