Search results for query: *

I'm not sure it will looks good, but back to original question you can split your text by " " (space) and when reassemble line back insert new line after every 5 array alements

Put password in variable and use expressions to configure connection with password from variable

Add logging to text file to your SSIS it will give you more details on error...

Just add script task and in VB or C# if your file YourFileName.csv_2015-12-09_21-17-47.zip In VB it would be Dim fileFolder As String Dim dirDest As DirectoryInfo = New DirectoryInfo(fileFolder) For Each f In GetFiles("YourFileName.csv*.zip") ' unzip your file there Next

...Data Source=" &_ Server.MapPath("x\db.mdb") & ";" myconn.open (connection) set rs = Server.CreateObject("ADODB.recordset") sql = "select * from PaxName where PaxName = ''" rs.open sql, cn, 1, 3 '1 - adOpenKeyset , 3 - adLockOptimistic rs.addNew rs("PaxName") = PaxName rs.Update rs.close...

I hope you understand risk of SQL injection when using inline insert statement what if PaxName = "antony; delete from PaxName;" sql = "INSERT INTO table (PaxName) VALUES ('" & PaxName & "')" In your case it will give you sql error, but code executes on database side, so it will delete all...

The simple way is something like that in Data flow source you running SQL somthing like select field1, field2, field3, field4, field5, field6, field7, ........... fieldN from sourceTabel You need to change to Declare @LastImportDate date select @LastImportDate = value from ParamSettings where...

...and refill with status 'P'. After that "select top 1 @vieName = vieName from myViews where status_cd = 'P'" and "select @isLast = case when count(*) = 1 then 'Y' else 'N' end from myViews where status_cd = 'P'" and last one "select isLast = @isLast , vieName = @vieName" 4. set property on...

try something like that If ds.Tables,Count > 0 Then if ds.Tables(0).Rows.Count > 0 then Dim dr As DataRow = ds.Tables(0).Rows(ds.Tables(0).Rows.Count - 1)) t1.Text = dr.Item(0).ToString end if End If or preferable change your query to "select top 1 field from table order by field...

IS step which giving error update records? If not make sure you use (nolock) attribute when query tables. Search on server log what else running on server at the same time may be problem not in your ssis, but on another process.

it looks like to stand alone queries so first one should be something like ; with e as ( select MIN_anty_pymt_dt = min(anty_pymt_dt), recip_ssn_nbr from dsnp.pr01_t_anty_pymt GROUP BY recip_ssn_nbr ) SELECT a.RECIP_SSN_NBR, CASE when a.RECIP_TYPE_CD = '10'...

It is number of ways to handle identity columns in replication (if you use identity columns). Even if you not doing anything when you set up replication system will create additional columns with and system tables which will track and handle all conflicts It is works pretty well.

It is transparent. I used that architecture. One server in central office and servers in different locations witch connected to internet and running VPN into central office network.

make right order on SQL side and after that just send result for file in SSIS

cross apply is analog to inner join, it works created to work with table valued functions if query select F.* from sys.objects O inner join dbo.myTableFun(O.name) F on F.schema_id= O.schema_id giving syntactic error query select F.* from sys.objects O cross apply dbo.myTableFun(O.name) F...

why no simple where ISNULL(@ParameterValue, '') = ISNULL(ColumnValue, '')

Is that one file with multiple tabs or multiple excel files? if it is one file, file will be on lock until all data flow tasks completed. you should put all your data flow tasks in one Sequence Container and File System Task after Sequence Container

...'Pended' union select 104, 5551111,'CS', 'Closed' union select 105, 5551111,'Support', 'Open' union select 106, 5553333,'CS', 'Open' select t.* from @Table t join ( select phone, recid = MAX(UniqueRecord) from @Table group by phone ) u on u.recid = t.UniqueRecord order by...

it looks like your problem outside of your published code... look on commented html...

Yes Chris absolutely right... you can stick somewhere in javascript array of holidays and check against that array or use ajax call from javascript to server with selected value and get from another asp page on server result