Trying to load Flat File to SQL Server. Number of columns in Flat file

ProductID - two-byte signed integer [DT_I2]

Name -Unicode string [DT_WSTR](50)

ProductNumber-Unicode string [DT_WSTR](25)

MakeFlag-Boolean [DT_BOOL]

Getting issue with last column 'MakeFlag'.

I...

This problem occurs only in the case of inserting rows into existing table.

while importing data from Flat File to SQL Server if you specify new table rather than existing table...

- When i upload the flat file as destination. Data types for all the columns is string[DT_STRING] this is expected behavior. The maximum size for the particular column(ModifiedDate) is...

For the last two days i scratched my head day and night,but was unsuccessful.Tried all whatever i had. I have attached the doc file steps i have followed. Tried all...

Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "ModifiedDate" returned status value 4 and status text "Text was truncated or one or more characters...

Thanks it worked and thanks for clarifying !!!!

What i can think of

Use OLE DB Source and select either 'SQL Command from variable' and 'SQL Command'

In 'SQL command' you can execute the same syntax...

Thanks gUYS

Yes i the query is working fine. Only issue i am facing is months are not arranged in sequential order

2001Q3August2605514.9809

2001Q3July1172359.4289

2001Q3September2073058.5385

2001Q4December3097637.3384

2001Q4November3690018.6652

2001Q4October1688963.2744

2002Q1Feburary3130823.0378

2002Q1January1605782.1915

2002Q1March2643081.0798

2002Q2April1905833.9088

2002Q2June2546121.9618

2002Q2May3758329.2949

For Quarter3 we can observe August comes first,then July and Setpember

I Have come up with this query.

WITH C AS(

select

year(OrderDate) AS OrderYear,

MonthForTheYear= CASE WHEN MONTH(OrderDate)=1 THEN 'January'

WHEN MONTH(OrderDate)=2 THEN 'Feburary'

WHEN MONTH(OrderDate)=3 THEN 'March'

WHEN MONTH(OrderDate)=4 THEN 'April'

WHEN MONTH(OrderDate)=5 THEN 'May'

WHEN...

I am struggling to write,not able to come with any logic. Any Any body guide me please

There are lot of ways to do it.Please explore by your self or Google it:-)

OK Will Check again 🙂

I do not get any error message.When i execute the query i get the message

(0 row(s) affected)

this can be achived using corelated sub query

select * from ClientDetails a where InterviewDate =

(select MAX(InterviewDate) from ClientDetails b where a.ClientID=b.ClientID)

order by 1 asc