Viewing 15 posts - 31 through 45 (of 49 total)
This is unedited other than deleting lines so it is small enough.
April 9, 2020 at 4:50 pm
I've attached a sample text and the import specs. Thanks!
April 9, 2020 at 4:04 pm
Thanks. I think they are the same when including spaces. They come from the government as a .dat file and they won't change so I'm stuck with these. I've added...
April 9, 2020 at 11:51 am
Thanks. Unfortunately I do not have ssis. Only SSMS.
April 7, 2020 at 3:47 am
Right now they are being imported into access. There is one spec for the rows that start with '1' and one spec for the rows that start with '2'. Then...
April 6, 2020 at 10:53 pm
Do you mean the spec part? If so that is just a sample of the first few. I can post them all if needed.
April 6, 2020 at 8:53 pm
I have a date calendar table. I'm just not sure how to use it to find the weeks between a date range.
April 2, 2020 at 2:10 am
What do you mean by real dates?
December 27, 2019 at 4:46 pm
Thanks. Yeah it is really bad data and no one here cared about the data types. They thought making dates integers would fix the y2k issues that never happened in...
December 26, 2019 at 5:04 pm
How do I find the domain account?
December 13, 2019 at 12:31 pm
Do you mean this?
December 9, 2019 at 8:23 pm
This was removed by the editor as SPAM
December 3, 2019 at 7:45 pm
I do not have any excel files open. Where do I look to show what is wrong? I am logged in using the admin account and the letter is directly...
December 3, 2019 at 6:22 pm
I'd like to know if that is the proper way to set it up. Message is below.
Started: 9:48:28 AM
Error: 2019-12-02 09:48:29.50
Code: 0xC0202009
Source: TEST Connection manager "DestinationConnectionExcel"
Description: SSIS Error Code DTS_E_OLEDBERROR....
December 2, 2019 at 6:17 pm
That is not the issue. The job runs but is failing. The message you are looking at does not allow someone to schedule.
December 2, 2019 at 6:08 pm
Viewing 15 posts - 31 through 45 (of 49 total)