What is your Target server set to in VS?

I miss read the question. I am importing a flat file with header and detail records to the database. Strike my answer.

Timing is everything. I have a similar project except it uses flat files with header and detail records. My problem was that the header would not get saved before the...

• This reply was modified 2 years, 3 months ago by  wburke 85918.

A few years back I had a similar issue of finding abnormal values in a table. I found some articles about how to identify Gaps and Islands a in data. ...

• This reply was modified 2 years, 3 months ago by  wburke 85918.

Phil, You have gotten me closer than I have been. Your solution was...

• This reply was modified 2 years, 4 months ago by  wburke 85918.
• This reply was modified 2 years, 4 months ago by  wburke 85918.

I know its kind of forced in that, we use whatever the PC_CompType's are on first Package, for all the packages in the set. I think maybe we should just...

Wow, that's a very good article Jeff, comparing Pivot to Cross Tabs. I was noticing all your Pivots always have aggregate functions. What I am doing seems to involve grouping...

• This reply was modified 2 years, 4 months ago by  wburke 85918.

Phil, its not that your solution didn't have merit. I was able to jazz it up by using a UNION, got close but no cigar. Still the issue with the...

• This reply was modified 2 years, 4 months ago by  wburke 85918.

Thanks for your reply Phil, Someone suggested PIVOT would do this, so I was trying to figure out how to do that. While this would be the answer if the...

• This reply was modified 2 years, 4 months ago by  wburke 85918.

Yes you are right EBCDIC and ASCII have different binary value sets. For example, "a" is less than "A" in EBCDIC, but "a" is greater than "A" in ASCII. Numeric characters are less than any alphabetic letter in...

I believe that Phil is correct. When we updated from 2008 to 2019 I tried several versions of VS. For me VS 2016 was where I found our SSIS packages...

• This reply was modified 2 years, 6 months ago by  wburke 85918.

Are you sure it sounds like you want "9-12 2021" as in September-December 2021.

Select MIN(Month), '-',MAX(Month), Year

or

SELECT Select MIN(Month), '-',MAX(Month), '-' Year

• This reply was modified 2 years, 9 months ago by  wburke 85918.

There is a STRING_Split function. If you are using a SSIS package why not use a Script component to split the string? Its the easiest way to get what yo...

Unfortunately Automated\Custom aren’t in the same realm. You can use Scrip Table as in SSMS. Then order you columns in the order you want. Combine them in one query with...

• This reply was modified 2 years, 9 months ago by  wburke 85918.

One would think any programming language will do a character by character compare when dealing with Character fields. Someone once told me, "Searching on Numeric data is always faster".  I don't...